Table Field saying "Unknown function 'Date' for default funtion?

M

Musik Man

Setting up a Field in a table for a value (date) that will be filled in
automatically in a Form. Using the Access 2000's default value for this date
function: ' date() ', I receive an error message when trying to save this
change: "Unknown function 'Date' in validation expression or default value on
'tblTracking 2007Q1.Request Date'. Is there something else I can do or is
there a defect in this application? ALSO tried to enter this function in the
actual Form Field with the results that returned " #Name ' instead of today's
date??
Any Help Please!
 
J

Jeff Boyce

It sounds like your database has a MISSING reference.

Open a code module (or code behind form). Click on Tools | References.

Are any of the checked references prefixed with MISSING?

If so, uncheck (note which one) and save, then re-open, recheck and save.

Finally, use Debug | Compile ...

Does that resolve the issue?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
C

CyberTaz

This triggers an ancient image in my mind, but I'm not sure - Try using the
NOW() function instead.
 

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

Similar Threads

Use TODAY() function as the criteria in a SUMIF formula 1
Default Value as last date in a table? 5
Why do I get "unknown function 'date'" 1
Default Value in Table 2
FileDateTime function in a query 6
dafault value for date not working with Date() but Now() is workin 5
Change default date for Date Picker in 2007 4
Default Data in table view 4

Top