Tim,
I assume the field has a default set in the table design. You can do the same in SQL Server by opening the table in design view and setting the default to GetDate().
Your other option in Access would be to set the default of the controls on forms to Now().
Duane Hookom MVP
MS Access
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Fri, 29 Aug 2014 07:59:49 -0700
Subject: [MS_AccessPros] Import Default date Now() in Access to SQL Server
Hi, would any of you please help me with this issue?
I created a form that has a default date as NOW() in my Access (2013) which works fine when I use Access. However, when I import my Access via SQL Server Migration Assistance into SQL Server 2012 so others can use the front end, I lose the defaut NOW () feature. Is there a way to get SQL Server to recognize the default date as today's date in its form?
Thanks in advance for your help!
Tim
I assume the field has a default set in the table design. You can do the same in SQL Server by opening the table in design view and setting the default to GetDate().
Your other option in Access would be to set the default of the controls on forms to Now().
Duane Hookom MVP
MS Access
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Fri, 29 Aug 2014 07:59:49 -0700
Subject: [MS_AccessPros] Import Default date Now() in Access to SQL Server
Hi, would any of you please help me with this issue?
I created a form that has a default date as NOW() in my Access (2013) which works fine when I use Access. However, when I import my Access via SQL Server Migration Assistance into SQL Server 2012 so others can use the front end, I lose the defaut NOW () feature. Is there a way to get SQL Server to recognize the default date as today's date in its form?
Thanks in advance for your help!
Tim
__._,_.___
Posted by: Duane Hookom <duanehookom@hotmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar