Date() function returns error

  • Thread starter Thread starter WiLL
  • Start date Start date
W

WiLL

In a new query, form, or report any function including Date
() will return the #NAME? error. ANY function including
Date(), including Date() itself (at the bottom of a
report, etc). What have I done? How can I fix it?

Thank you very much in advance,

WiLL
 
In a new query, form, or report any function including Date
() will return the #NAME? error. ANY function including
Date(), including Date() itself (at the bottom of a
report, etc). What have I done? How can I fix it?
Click to expand...

This appears to be the very common References bug. Open any
module in design view, or open the VBA editor by typing
Ctrl-G. Select Tools... References from the menu. One of the
..DLL files required by Access will probably be marked
MISSING. Uncheck it, recheck it, close and open Access.

If none are MISSING, check any reference; close and open
Access; then uncheck it again. This will force Access to
relink the libraries.
 
That didn't work. The problem also extends itself to Now
(), and also CurrentUser(). I am confused now, and am
having paranoid thoughts about viruses, corrupt sectors or
libs, invalid config files, and other nasties.

The database is accessable through a shared network, and
the other terminals (with their own access installs) are
having the same problems, so reinstalling won't help.
PErhaps my .mdb is corrupt?

I also tried "repair and compress" but it neither repaired
nor compressed the database.

I am sooo lost its like im a noob all over again, perhaps
it's some dumb user error I didn't see?

any ideas?
 
Back
Top