DATE function will not work

  • Thread starter Thread starter Emma
  • Start date Start date
E

Emma

I've converted a database from 97 to 2000 and the =date()
function will not work.

It just doesn't work at all!

I get the following error message: Unknown function 'Date'
in validation expression or default value on 'Table1.Date'.

Please help.
 
Emma

That sounds like Access has "forgotten" where one/more of its References
are.

Open a code module, select Tools|References.

I'm guessing that one/more shows MISSING.

Note which ones are so marked, then attempt to uncheck those. Accept
(OK/Save) the change.

Now go back in and re-check those you unchecked. Accept again.

Re-compile (Debug|Compile). Save. Exit.

It should be working now.
 
Back
Top