Tim-
The simplest thing to do would be to open the form you use to edit the data and set the Default Value property of the control that edits the date to either =Date() or =Now(). (Now give you date and time.) You could set a default value in the SQL Server table, but the server will supply that value on a new row only if no value is supplied in the INSERT executed by Access. You won't see that default on your form.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Aug 29, 2014, at 4:59 PM, timdbui@gmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
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: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar