DATE() criteria won't work w newer OS

paulhh

Registered User.
Local time
Today, 17:21
Joined
Dec 10, 2002
Messages
12
Using Access97 the criteria is
(Date()) And ([EDJC])
Database is multiuser setup on Server.
Any computer using Win98 works perfectly.
2000, NT, and XP give error
"Function isn't available in expressions in query expression "(((Schedules,SchDate)=(Date()) AND ..."

If I change it to NOW() the error goes away but I get no output.

On a test machine I converted it to Access2002 but get same error.

Any Suggestions?
 
The problem is caused by a reference error. Different operating systems store shared system .dll's in different directories and of course the .dll's would also be different versions. Access cannot automatically reconcile these differences. Usually the culpret is the DAO 3.6 library.

To resolve the problem, open the db on the machine where it is experiencing the error. Open any code module. Choose references from the Tools memu. You may or may not see a reference marked "MISSING". In any case, uncheck the box next to any reference except the first two. Close the references dialog. This forces Access to refresh its references correction and usually fixes the problem. If not, you may actually need to locate a missing .dll or install it. Search the archives here for LOTS of posts on the topic.
 
Lost reference after unclicking it?

Thank you, I had read several dozen messages before asking. But don't have any modules set up, finally figured out I could CTRL+G get to reference area.

On my machine where date worked fine but Calendar had started acting up it stated "Missing Microsoft Calendar Control 8.0" so I unchecked it and exited program, then went back in to recheck it and can't find it in the list. Did a find on Calendar but couldn't find it and suggestions.

It looks like one of the other computers need "MSInfo MSIAV Category Module" as it can find the "Microsoft DAO 3.51 Object Library" but am afraid to try it untell I find out how to get mine back. You mentioned the DAO 3.6 library - do I possibly need to update the DAO 3.51 to get the date?

All this is new to me - am just trying to modify an existing program.

Thanks for all your help.
Paul

P.S. Have since solved this as well. Pulled it off the web and loaded it. My date function now works. Thanks.
 
Last edited:
Paul,

I am having same problem in outpost office.
HOW exactly did you solve it?

Thanks.

Russ
 

Users who are viewing this thread

Back
Top Bottom