Undefined function 'Date' in expression

[Tim]

I have a form (MS Access 2003 frontend) that had worked well before and then
now when I open that form, suddently there is an error message pop up,
"Undefined function 'date' in expression". I have another database with
similar designing that works just fine!
Can you please tell me why is it? I recently convert the backend to SQL
Server 2005. Maybe it's corrupted?
Thank you in advance for your help - tim

 

[Klatuu]

More likely, it is a missing reference problem in VBA. Look at the
references in the working database and see if there is one missing in the non
working database. I don't remember which library the Date function is in,
but this is the usual cause of this problem.

 

[Tim]

Dave,
Thank you for your comment. Missing reference is the first thing I thought.
I did check the reference in VBA, but I can not find the **Missing** listing.
tim

 

[Klatuu]

It can still be a missing reference problem. the **missing** means the
reference has been identified, but the file of the reference can't be found.
It the reference has not been established or has been lost or accidentily
removed, you will not see the **missing**

 

[Douglas J. Steele]

If none of the references show up as "MISSING:", what can help is adding an
additional reference at random, backing out of the dialog then going back in
and unselecting the reference you just added.

If that still doesn't work, try to unselect as many of the selected
references as you can (Access may not let you unselect them all), back out
of the dialog, then go back in and reselect the references you just
unselected. (NOTE: write down what the references are before you delete
them, because they'll be in a different order when you go back in)