Date() and Now() no longer recognized

georget

Registered User.
Local time
Today, 00:49
Joined
Jul 17, 2002
Messages
31
Hi, I have a replica database in Access 2000.

I changed a form in the design master that had nothing to do with the date or a date field. Everything appeared fine.

Now I updated the replicas, and an error is happening on all replicas as well as the design master. Any reference to Date() or Now() causes errors.

If it's a field on a form it has an #Name error. If Date() or Now() is on a report, a popup to enter parameters appear for the date. This database with these codes have been working for years.

Is it safe to say it's no longer recognizing Date() or Now() ?

Any ideas on a fix?

thanks
 
Did you try to Compact and Repair?
 
You have a missing/broken reference by the sound of it, try searching here for solutions to the problem
 

Users who are viewing this thread

Back
Top Bottom