Problems with "Date()" &"Time()"

[Geo]

I am working an MS Access db for controlling contractor access to controlled facilities. Throughout the db I use the function "Date()" and "Time()". Recently the db program has been producing errors that basically state the functions are not recognized. The same error has occurred in two different developing environments. I would appreciate any ideas? Thanks!! Ge

 

[Cheryl Fischer]

When the common, built-in functions produce errors, this is typically a
"references" problem. Here are two links with information on how to
diagnose and fix references:

http://allenbrowne.com/ser-38.html

http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html


--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX

I am working an MS Access db for controlling contractor access to

controlled facilities. Throughout the db I use the function "Date()" and
"Time()". Recently the db program has been producing errors that basically
state the functions are not recognized. The same error has occurred in two
different developing environments. I would appreciate any ideas? Thanks!!
Geo

 

[Geo]

This is great, thanks!