Cannot tranfer Database with Date Function query

I

Ian Potter

I have created a query to look up the records foe today's date by using
Date() in the criteria for the field OrderDate.
This works fine! So I created a Form using the query to make it easier for
the user to look up today's records, that worked fine!
My problem is that I have used a Flash Memory Sitck to transfer my database
onto the users home computer, and she gets the following error message when
trying to open the form or run the query.
"error undefined function Date()"
I have looked this up using help but cannot understand how I can overcome
the problem.
I and she are using Access 2000.
Any ideas?
Thanks
Ian
 
J

John Vinson

My problem is that I have used a Flash Memory Sitck to transfer my database
onto the users home computer, and she gets the following error message when
trying to open the form or run the query.
"error undefined function Date()"
Click to expand...

This appears to be the very common References bug. Open any
module in design view, or open the VBA editor by typing
Ctrl-G. Select Tools... References from the menu. One of the
..DLL files required by Access will probably be marked
MISSING. Uncheck it, recheck it, close and open Access.

If none are MISSING, check any reference; close and open
Access; then uncheck it again. This will force Access to
relink the libraries.

John W. Vinson[MVP]
 
I

Ian Potter

Thank You John,
That worked although I had to leave it unchecked to work
Regards
Ian
 
Top