Now/today function not working

[Guest]

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

 

[Michel Walsh]

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

 

[Allen Browne]

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

 

[Duane Hookom]

"Today()" is not a function in Access.

 

[OfficeDev18 via AccessMonster.com]

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