Date() & Time functions do not work

[JimRich]

I have installed a program on 4 different computers. On one of the computers the date and time functions do not work. It is running Windows98. I let Office2000 repair Access.

The rest of the program seems to be working fine. Any ideas as to what causes this problem.

Any help will be appreciated.

JimRich

 

[danvlas]

Have you checked the references?




Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[JimRich]

I have checked the references. What reference are you supposed to have to cause built in functions to work?

JimRich

 

[Dimandja]

Try looking in VBA editor > Tools > References... Of the checked references are any marked Missing? If so, uncheck the culprit.

In any case, MS has not been able to properly rein-in Date(); use Now() instead.

Dimandja

 

[JimRich]

If the reference is marked "Missing" and the file needed is not on the computer and reinstalling Access does not install it, what would you do?

I am also using "Date" in a couple of date math functions and I get an error message there as well.
DateAdd("ww", 1, Date)I have never tried using NOW() in these functions.

Thanks for the quick responses. This has been stumping me two days.

JimRich

 

[danvlas]

If the reference is marked "Missing" and the file needed is not on the computer and reinstalling Access does not install it, what would you do?"

I'd uncheck it and get rid of it for good.
If program doesn't work any longer, you will have to install the referenced library on the offending computer...

HTH





Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[Dimandja]

Follow my previous instructions. If you are still having problems, we'll cross that bridge in due time.

 

[stingers]

Follow the resolution section in this link. I have had similar problems and this worked for me. What is the exact error message you get?

http://support.microsoft.com/default.aspx?scid=kb;en-us;194374&Product=acc97