query problems

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

I have a large database on a corporate share drive. When I
access the database from a desktop computer on the network
everything works fine. But if I access the database on my
company laptop I get date and funtion errors anytime I use
Date() or any other type of calculation. If I run a query
with no date restriction or expressions it works fine. I
checked the global date setting to make sure they were
correct and they are. Is there any reason that I am
getting these errors? I could not find anything under the
help menu either. Please help!!
Thanks
Mike
 
Dear Mike:

You may have what is called a "references" issue; this is a common problem.
Here's a description of the cure and various links written put together by
Jeff Conrad. (I'm lazy, so I've just cribbed from Google groups... ;)

<quote>
The arch-nemesis of Access is missing references.

To fix the References problem follow these steps:
- Open any module in Design view.
- On the Tools menu, click References.
- At least one Reference should say "Missing". WRITE down the one(s)
missing.
- Click to clear the check box for the type library or object library marked
as "Missing:."
- Close the References Window box.
- Open the References Window back up. Hopefully, nothing should say Missing
this time.
- Now go find that library/project(s) in the list that was missing.
- If more than one were missing, find the others and check them as well.
- Close the References box again.
- Now re-compile again. Debug--Compile.
- Hopefully you should not see any more compile errors.

If you'd like to read more about References, here's more info than you could
possibly ever want to
know:

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

http://www.papwalker.com/dllhell/index-page2.html

ACC2000: How Access 2000 Resolves Visual Basic for Applications References
http://support.microsoft.com/?id=248941

ACC2000: How to Resolve Reference Issues in an Access Database
http://support.microsoft.com/?id=310803

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

--
Jeff Conrad
Access Junkie
Bend, Oregon

<end quote>

HTH
Fred Boer
 
Back
Top