=Date() not picking up system date

[Guest]

Hi. I am a novice at Access. I had a Access databse created in 2000 version.
Last week I converted it to 2002/3 version using the auto convert feature.
Now I find all teh queries and forms picking up the system date using =Date()
comes back with #Name? Creating a new form using the insert Date and Time
comes back with the same #Name? Has any one got an answer as to why it
doesn't pick up the system date. This is happening on multiple computers.

 

[Allen Browne]

Sounds like a problem with library references:
http://allenbrowne.com/ser-38.html

 

[Ken Snell \(MVP\)]

My guess.... you have a field or a control named Date in the database. It
and many other words are reserved words in ACCESS and should not be used for
control names, field names, etc. See these Knowledge Base articles for more
information about reserved words and characters that should not be used:

List of reserved words in Access 2002 and Access 2003
http://support.microsoft.com/default.aspx?scid=kb;en-us;286335

List of Microsoft Jet 4.0 reserved words
http://support.microsoft.com/?id=321266

Special characters that you must avoid when you work with Access
databases
http://support.microsoft.com/?id=826763


See this site for code that allows you to validate your names as not being
VBA keywords:

basIsValidIdent - Validate Names to Make Sure They Aren't VBA Keywords
http://www.trigeminal.com/lang/1033/codes.asp?ItemID=18#18