=Date() function doesn't work

[Guest]

I recently formatted a machine and reinstalled window 98. It also
reinstalled all apps and an Access 2000 database that is the reason for the
computer. Since the reinstall, it seems the dates throughout the database
are wacky and the insert date and time function (and =Date( ) for today's
date) doesn't work. Is this a glitch in the reinstall of Win98 or is this a
function of Office 2K?

Any help would be greatly appreciated.

 

[Douglas J Steele]

It's probably a problem with your References collection.

Access stores information about external files it needs in the References
collection. If the files referred to are not the same, a problem can arise.

With any code module open, select Tools | References from the menu bar.
Examine all of the checked references. If any have "MISSING:" in front of
them, uncheck them (write down what they were, in case you have to add them
back in later: they will not be in the same location when you go back into
the list of References!) You can tell if you need them by going to the Debug
menu and compiling your application. If no errors arise, you didn't require
the reference that was removed.

Note that the reference that's broken may have nothing to do with the Date
function itself. References are like apples: one bad one can spoil the whole
bunch.

 

[Tanis]

Without knowing the exact nature of the problem, 'doesn't work' is no
really enough to go on, I suggest you look at the references o
formatted machines DB. Make sure there are none missing and make sur
that the references are the same as on the othe machines. Do
compile, compact and repair, That may solve the problem

 

[Guest]

Thanks for the help. Prior to you answer, I determined the problem did lie
within the database and was able to replace the affected frontend and get the
database up and running. I will use your answer to teach myself how to deal
with a 'missing' reference and be better able to deal with this situation in
the future. Thank You!