Go Back   Access World Forums > Microsoft Access Discussion > Tables

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 09-12-2017, 04:48 PM   #1
cheer
Newly Registered User
 
Join Date: Oct 2009
Posts: 182
Thanks: 6
Thanked 0 Times in 0 Posts
cheer is on a distinguished road
Date Type Default Value : =Date() Error

Can anyone suggest how to fix the error inside the attachment ?
Attached Images
File Type: jpg Date.jpg (74.0 KB, 27 views)

cheer is offline   Reply With Quote
Old 09-12-2017, 06:09 PM   #2
arnelgp
Newly Registered User
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 3,736
Thanks: 46
Thanked 1,267 Times in 1,199 Posts
arnelgp has a spectacular aura about arnelgp has a spectacular aura about
Re: Date Type Default Value : =Date() Error

Press the ellipse there and see if yiu can set ut there otherwuse do it in the form
__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
Old 09-12-2017, 08:26 PM   #3
JHB
Have been here a while
 
Join Date: Jun 2012
Location: In the south of Denmark (Jutland), near the German border.
Posts: 6,701
Thanks: 2
Thanked 1,778 Times in 1,744 Posts
JHB will become famous soon enough JHB will become famous soon enough
Re: Date Type Default Value : =Date() Error

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

__________________
If the above post has helped you, why not take the time to say thank you, by pressing the "Thumbs up."
JHB is offline   Reply With Quote
Old 09-12-2017, 11:35 PM   #4
Gasman
Access newbie
 
Join Date: Sep 2011
Location: Swansea, South Wales,UK
Posts: 1,378
Thanks: 171
Thanked 198 Times in 184 Posts
Gasman will become famous soon enough
Re: Date Type Default Value : =Date() Error

I only have
Date()

in one of my tables
__________________
Access novice. Sometimes trying to give something back.
Access 2007
Gasman is online now   Reply With Quote
Old 09-13-2017, 08:41 AM   #5
Mark_
Newly Registered User
 
Join Date: Sep 2017
Posts: 33
Thanks: 0
Thanked 5 Times in 5 Posts
Mark_ is on a distinguished road
Re: Date Type Default Value : =Date() Error

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.
Mark_ is offline   Reply With Quote
Old 09-13-2017, 04:28 PM   #6
cheer
Newly Registered User
 
Join Date: Oct 2009
Posts: 182
Thanks: 6
Thanked 0 Times in 0 Posts
cheer is on a distinguished road
Re: Date Type Default Value : =Date() Error

Quote:
Originally Posted by Mark_ View Post
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 is offline   Reply With Quote
Old 09-13-2017, 04:29 PM   #7
cheer
Newly Registered User
 
Join Date: Oct 2009
Posts: 182
Thanks: 6
Thanked 0 Times in 0 Posts
cheer is on a distinguished road
Re: Date Type Default Value : =Date() Error

Quote:
Originally Posted by JHB View Post
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

Error in loading the DAO dll file under the MS Access 2016

cheer is offline   Reply With Quote
Old 09-13-2017, 04:33 PM   #8
cheer
Newly Registered User
 
Join Date: Oct 2009
Posts: 182
Thanks: 6
Thanked 0 Times in 0 Posts
cheer is on a distinguished road
Re: Date Type Default Value : =Date() Error

I have export the whole objects into the a ACCDB file and it works now as Date(). Thanks for everyone help.

cheer is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
setting default value of date in detail table as date value of master fady Introduce Yourself 2 10-14-2014 02:05 AM
Date import from excel to access - type mismatch error ketangarg86 General 1 09-17-2014 03:06 PM
Setting default date & time in a date range form ptaylor-west Forms 5 01-18-2007 11:16 AM
Run Time Error 13 - Type mismatch, Something to with Date?? mickey_lin_uk Modules & VBA 14 01-07-2005 12:27 AM
Date() as default value is error #Name? eason Forms 8 10-24-2001 07:03 AM




All times are GMT -8. The time now is 11:46 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World