Date Type Default Value : =Date() Error

cheer

Registered User.
Local time
, 07:54
Joined
Oct 30, 2009
Messages
222
Can anyone suggest how to fix the error inside the attachment ?
 

Attachments

  • Date.jpg
    Date.jpg
    74 KB · Views: 126
Press the ellipse there and see if yiu can set ut there otherwuse do it in the form
 
If the syntax is correct and it seems to be, it could be a problem with missing references.
The link shows how to Check for it.
http://www.access-diva.com/d5.html
 
I only have
Date()

in one of my tables
 
Your default value should show

DATE()

Not

=DATE()

Access already knows you are setting the value equal to something so you don't have to put the equals sign in.
 
Your default value should show

DATE()

Not

=DATE()

Access already knows you are setting the value equal to something so you don't have to put the equals sign in.

Tested that Date() works fine under the MS Access 2000 and 2003, however, error displayed u8nder the MS Access 2016, 64 bits
 
I have export the whole objects into the a ACCDB file and it works now as Date(). Thanks for everyone help.
 

Users who are viewing this thread

Back
Top Bottom