Problem with Date

[GymBeef]

Using Win-95 and Access 97, my application seems to be conflicted about using the Date function to get the date. I'm using it to record the date that record was last changed, by setting:
fieldname=Date (or control=Date)
whenever a record is saved.

It keeps erroring out, and won't work at all when the application is run under NT. Everything in the help shows I'm doing it right, and the Now function which gets both date and time works OK, but Date is being problematic. Is it maybe a Y2K thing? My system is all updated though.

 

[R. Hicks]

You more than likely have a "Library Reference" problem on the machine giving you the error.
On the problem machine open a module in design view, or open a new module in design view, click the Tools button in Access main tool bar, then choose References. In the References list you will likely see a checked reference that has "Is Missing" message attached to it. This is the one causing the error. Uncheck the culprit and the problem should be cleared up.

I posted this reply on another site, maybe the info will give you some insight on what can cause this irritating problem:

Most of the time the problem originates from the machine where the Access app is written on. I have found this is commonly caused by someone using non-standard activeX controls and other components that are not basic to Access. If you play with an activeX component then even if you delete it from your application the library reference will still be loaded in the current app unless you uncheck the reference. Thus when you install the app on another machine the result will be a library reference error. Unless you are doing something exotic there normally should be only three references checked. For Access 97 these are:

Visual Basic For Applications
Microsoft Access 8.0 Object Library
Microsoft DAO 3.51 Object Library (version can vary)

If you are doing some things with Excel through Access you will also have an Excel Library check also. If you have others checked they can very well cause a problem if the other machines do not have the libraries registered on them. I hope I have explained this clearly enough. I too have encountered this problem in the past.

Good Luck
RDH