Date time functions missing in access 2000

  • Thread starter Thread starter Paulc123
  • Start date Start date
P

Paulc123

I hope someone may be able to help

I am running access 2000 on XP machines

I have the following expressions as validation rules on a form.

=Date() Or Is Null Or <1

(Between (Time()+0.005) And (Time()-0.005)) Or Is Null

The problem is that on some computers this works fine and on others
they seem to not work with the date and time function and i get a
message that i may have entered a non existent function.

I have 6 HP computers all identical including the software and on 3
they work and the other 3 they don't
Talk about even odds.

On the 3 that don't work even entering =date() in a text box in the
control source returns just the #name# error? So like I said it is as
if the date and time functions do not exist. However they do appear in
the inbuilt functions folder in the expression builder.

Any help would be appreciated
 
Allen

Thanks for your help but was not the cause although your website has
been helpful.

Problem was fixed by creating a new database and importing all the
forms, queries etc to the new DB.

Obviously something corrupt in the original DB file?

Thanks again
 
Paulc123 said:
Allen

Thanks for your help but was not the cause although your website has
been helpful.

Problem was fixed by creating a new database and importing all the
forms, queries etc to the new DB.

Obviously something corrupt in the original DB file?
Click to expand...

Not likely. If you had a missing reference and it was also a reference that
your file actually did not need (common) then creating a new file and importing
all objects would fix the problems because the new file would not have the
missing reference in it (those are mot included in the import).
 
Back
Top