Validation in entering data

  • Thread starter Thread starter russell_a_smith
  • Start date Start date
R

russell_a_smith

i am trying to update a database in Lotus APPROCH, it uses dbf tables. I can
open the tables in access, but need to set up some forms to add new data. I
need to validate a time feild so data is entered in 1/4 hr increments as a
decimal, ie 4.25 or 4.50.

The Approch database did this with the MOD command, but I can not get this
to work in access.

The formula was MOD(timetable.timefield/0.25)=0

so if the remainer divided by 0.25 was 0 then the data was entered ok.

Can anyone help me with this in access?

I have thought of a drop down list but data values could be upto 150hrs so a
long list!
 
so if the remainer divided by 0.25 was 0 then the data was entered ok.

Can anyone help me with this in access?
Click to expand...

Int(TimeField * 4)= TimeField * 4
i am trying to update a database in Lotus APPROCH, it uses dbf tables.
Click to expand...

... but if the data are still in dbf files, then I doubt that they are
capable of holding any kind of check contraints or validation rules.

You can put the validation in the ValidationRule of the control on the
form, or else use the BeforeUpdate event of the form or the control to do
the same thing.

Better would be to implement the whole thing in Access by importing the
tables and using the db facilities.

HTH


Tim F
 
Thanks that works a treat!

Russ
Tim Ferguson said:
Int(TimeField * 4)= TimeField * 4


... but if the data are still in dbf files, then I doubt that they are
capable of holding any kind of check contraints or validation rules.

You can put the validation in the ValidationRule of the control on the
form, or else use the BeforeUpdate event of the form or the control to do
the same thing.

Better would be to implement the whole thing in Access by importing the
tables and using the db facilities.

HTH


Tim F
Click to expand...
 
Back
Top