Undefined function 'Date' in expression.

S

SimonB

I am running Access 2002 on my PC and using a DB
application originally created in Access 2000 on another
PC. The DB application works fine on the other PC, but I
get some error messages when running it on my PC. Most
of it works fine on my PC, however.

One such error is that my PC does not recognize the Date
() function in a query in the application. My PC allows
me to create a query in a new database using the Date()
function, and it works fine there. But my PC just won't
recognize the same function in the DB application. The
error message is "Undefined function 'Date' in
expression." and help says it is (Error 3085).

Another error message I get is "Your Microsoft Access
database or product contains a missing or broken
reference to the file 'TA3D.OCX' version 1.0." I get
this when I load the DB application, but it clears itself
and does not prevent me from loading the application.

Any ideas of what might be going on? I can't find
anything in the knowledge base.
 
B

Bogdan Zamfir

The problem might be with that broken reference
When you have broken references, Access stops recognizing other function,
which actually have nothing to do with the missing reference

So you have to open References window, uncheck the problem reference, click
OK, then try your query again.

HTH,
Bogdan
_________________________
Independent consultant
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top