Now/today function not working

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

Guest

In my query none of the functions related to current date is working. Can
someone help me fix it. thanks.
purnima
 
Hi,


You probably have a problem of reference. Check under VBA code, from the
menu, Tools | References...

One of the checked reference may start its description with the word
MISSING. Try to uncheck it (or to install it, if that reference is really
required).


It is just due to the way Access works. As soon as an unloaded function
(Date(), Now(), in your case) is required, the references are checked, and
if one is missing, even if not related to your function (since it is
missing, Access does not know if the function is supplied by the missing
reference, or not), you get an error.


Hoping it may help,
Vanderghast, Access MVP
 
In other words, Purnima, replace all today() functions with the Date()
function. Today() is an Excel function that returns the current date. Date()
in Access does the same thing.

HTH
 
Back
Top