|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 22nd, 2010, 04:48 PM
posted to microsoft.public.access.forms
|
|||
|
|||
Time Stamp
How can I automatically populate the current date into a field for a new
record? Will this automation apply a new date to all records? 
|
|
#2
January 22nd, 2010, 05:01 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Time Stamp
Adam wrote:
How can I automatically populate the current date into a field for a new record? Will this automation apply a new date to all records? Set the default value to be Date(). This is done in the table design view. You can, obviously, set the format in the field to show only date, or date and time if you need to know the time of day the record was added.
|
|
#3
January 22nd, 2010, 09:38 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Time Stamp
Darrell's suggestion will work just fine, of course, but just so that you
know how to differentiate between new records and old records when doing something like this, you could also have used Private Sub Form_Current() If Me.NewRecord Then Me.TimeStamp = Date End If End Sub and only the new records would have been effected, with the existing records retaining their original creation timestamps. -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201001/1
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
