Access 2000 date error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We have a database at work that is used by many folks. One of the fields in
a form that is frequently used is supposed to show the current date. It
suddenly showed #Name in the box instead of the date. I traced the problem
back to the table where the date field is stored. It seems that there is a
problem with the date function. I cannot use any of the functions that
display a date except for the "Now" function. The Now function causes some
other issues and is not useable for what we need. If I use date() or Cdate()
I get an error message.

This problem appears for all of the users, so I am assuming that the problem
is in the table. How can I fix this? My users are not happy.

I hope that this is the correct place to post this request. Thanks for your
help.
 
I do not know which Object Library has gone missing, but your description
sounds like this is the problem. Check your Object Library references. If
you see one that says Missing, then the DLL or olb file that has date
functions in it is missing. If none or missing, then you need to find out
what reference to make. I wish I could be more specific, but I don't really
know all the different libraries and what they do. I have been through a
similar problem, however.
 
We have a database at work that is used by many folks. One of the fields in
a form that is frequently used is supposed to show the current date. It
suddenly showed #Name in the box instead of the date. I traced the problem
back to the table where the date field is stored. It seems that there is a
problem with the date function. I cannot use any of the functions that
display a date except for the "Now" function. The Now function causes some
other issues and is not useable for what we need. If I use date() or Cdate()
I get an error message.
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.

John W. Vinson[MVP]
 
Back
Top