Date() Function Question

Question

I am in the process of converting some databases from ACESSS 2003 to ACCESS 2010. I have a table that contains a date field formatted to reflect the short date. When I create a query to show me all records less than the current date utilizing <Date() in the criteria field of the query; I recieve an error that states undefined function 'date' in expression. This query criteria works in the database in access 2003. I have been able to replace Date () with Now() and the query works but this looks at current date and time.  I have many queries where I need to see items that have occurred prior to the current date and forecast events in the future based on this date field which I am utilizing the Date() function. What do I need to do to correct the error message I am recieving?

Thanks for your help in advance and have a nice day

Answer 1

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.

Answer 2

That fixed my issue. Thanks for the quick response and help.