Date Type Default Value : =Date() Error (1 Viewer)

cheer

Registered User.
Local time
Today, 10:10
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: 107

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 10:10
Joined
May 7, 2009
Messages
19,169
Press the ellipse there and see if yiu can set ut there otherwuse do it in the form
 

JHB

Have been here a while
Local time
Today, 03:10
Joined
Jun 17, 2012
Messages
7,732
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
 

Gasman

Enthusiastic Amateur
Local time
Today, 02:10
Joined
Sep 21, 2011
Messages
14,048
I only have
Date()

in one of my tables
 

Mark_

Longboard on the internet
Local time
Yesterday, 19:10
Joined
Sep 12, 2017
Messages
2,111
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.
 

cheer

Registered User.
Local time
Today, 10:10
Joined
Oct 30, 2009
Messages
222
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
 

cheer

Registered User.
Local time
Today, 10:10
Joined
Oct 30, 2009
Messages
222
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

Top Bottom