Date()

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

Guest

I have been using =Date() in a form to put today's date in a newly created record. Suddenly, for no apparent reason, the function stops working and the field shows an error. Doesn't Date() read today's date from the computer? How do I get this to work again?
 
Hi,

Just a guess here.
The machine may have a missing reference.
The arch-nemesis of Access is missing references.
Open any module in Design view.
On the Tools menu, click References.
Click to clear the check box for the type library or object library
marked as "Missing:."

An alternative to removing the reference is to restore the referenced
file to the path specified in the References dialog box. If the
referenced file is in a new location, clear the "Missing:" reference
and create a new reference to the file in its new folder.

See these links for more information:

http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

http://members.iinet.net.au/~allenbrowne/ser-38.html

http://www.trigeminal.com/usenet/usenet026.asp

ACC2002: References That You Must Set When You Work with Microsoft Access
http://support.microsoft.com/?id=283115

ACC97: References That You Must Set When You Work with Microsoft Access
http://support.microsoft.com/?id=175484

ACC: VBA Functions Break in Database with Missing References
http://support.microsoft.com/?id=160870

Hope that helps,
Jeff Conrad
Bend, Oregon

LannesD said:
I have been using =Date() in a form to put today's date in a newly created
Click to expand...
record. Suddenly, for no apparent reason, the function stops working and
the field shows an error. Doesn't Date() read today's date from the
computer? How do I get this to work again?
 
Back
Top