UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Default Value In Field, Access 2010    
 
   
AlBilly
post Jan 4 2017, 02:59 PM
Post#1



Posts: 105
Joined: 23-September 16



Hi,
I am working on some VBA to add new field to tables, I would like to know on how to set up a specific format on date fields, This is the actual SQL to make the modification
CODE
ALTER TABLE tblUtilisateurs ADD COLUMN DateCreation Date/Heure DEFAULT GetDate()


Thanks
Go to the top of the page
 
theDBguy
post Jan 4 2017, 03:15 PM
Post#2


Access Wiki and Forums Moderator
Posts: 70,666
Joined: 19-June 07
From: SunnySandyEggo


Hi,

Not sure if it's possible with DDL statements. You might have to use a DAO object.

Just a thought...

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Microsoft Access MVP | Access Website | Access Blog | Email
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    22nd September 2017 - 03:28 PM