Validation in entering data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

russell_a_smith - 14 Apr 2005 18:58 GMT

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!

Reply to this Message

Tim Ferguson - 14 Apr 2005 20:15 GMT

> so if the remainer divided by 0.25 was 0 then the data was entered ok.
>
> Can anyone help me with this in access?

Int(TimeField * 4)= TimeField * 4

> i am trying to update a database in Lotus APPROCH, it uses dbf tables.

... 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

Reply to this Message

russell_a_smith - 16 Apr 2005 09:36 GMT

Thanks that works a treat!

Russ

>> so if the remainer divided by 0.25 was 0 then the data was entered ok.
>>
[quoted text clipped - 17 lines]
>
> Tim F

Reply to this Message