date function in access 97

  • Thread starter Thread starter don
  • Start date Start date
D

don

My database does not recognize the date function. Another
database that i use works fine with the date(). Any idea
what needs to be done to correct the problem?
 
My database does not recognize the date function. Another
database that i use works fine with the date(). Any idea
what needs to be done to correct the problem?
Click to expand...

Hi Don,

This is usually a missing reference. In any code window, click
Tools..References and see if any are marked MISSING. These will cause
an overall compile error, and many common functions like Left() and Date
() won't work.

You need to either find the object that was registered, or remove that
reference if it is not necessary (which is often the case).

The reference list is kept with each database, which explains why other
databases work correctly.

Hope this helps,
 
Most likely a problem with the References on that machine. Go to any code
window, choose Tools > References. Find any that say MISSING and uncheck it
and click OK. That solves most problems of this type.
 
Back
Top