Problem using date() on different computers.

C

Co9ug9ar

I have recently created a database to keep track of some records and create
some reports based on dates. On my computer all the queries and reports
worked fine using the date() function. But when I went to show the person
who asked for the program I got an error saying 'undefined date in
expression'. All of the records were still there, but a few of my queries
wouldn't run and all the formulas I had in my reports that used the date()
came up as errors. I have opened the datebase on several computers and mine
was the only one which worked correctly.

Anybody know what is wrong with this, or have any suggestions on how to fix
this situation?

Thanks,
Keith
 
B

Brian

Co9ug9ar said:
I have recently created a database to keep track of some records and create
some reports based on dates. On my computer all the queries and reports
worked fine using the date() function. But when I went to show the person
who asked for the program I got an error saying 'undefined date in
expression'. All of the records were still there, but a few of my queries
wouldn't run and all the formulas I had in my reports that used the date()
came up as errors. I have opened the datebase on several computers and mine
was the only one which worked correctly.

Anybody know what is wrong with this, or have any suggestions on how to fix
this situation?

Thanks,
Keith
Click to expand...

I don't think it said "undefined date", I think it said "undefined
function". See:

http://www.mvps.org/access/bugs/bugs0001.htm
 
J

John Vinson

Anybody know what is wrong with this, or have any suggestions on how to fix
this situation?
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]
 
Top