Cannot tranfer Database with Date Function query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ian Potter - 24 Mar 2006 15:27 GMT

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

Reply to this Message

John Vinson - 24 Mar 2006 22:37 GMT

>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()"

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]

Reply to this Message

Ian Potter - 25 Mar 2006 13:13 GMT

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

>>My problem is that I have used a Flash Memory Sitck to transfer my
>>database
[quoted text clipped - 14 lines]
>
> John W. Vinson[MVP]

Reply to this Message