| | |
|
|
|
Create Date |
|---|
| message from =?Utf-8?B?TGF1cmE=?= on 25 May 2004 |
How do I add a Create Date/Time field to a table that will recored the date/time a record is created? This has to be an easy one.
|
| Douglas J. Steele replied to =?Utf-8?B?TGF1cmE=?= on 25 May 2004 |
Add a field to the table and set its default value to Date() for date only,
or Now() for date and time.
|
| Brian Kastel replied to Douglas J. Steele on 25 May 2004 |
Even Better! Thanks.
|
| =?Utf-8?B?TGF1cmE=?= replied to Douglas J. Steele on 25 May 2004 |
I was assuming that date() and now() would change the date everytime the table was modified, versus the date staying as it was when the record was created.
|
| Douglas J. Steele replied to =?Utf-8?B?TGF1cmE=?= on 25 May 2004 |
"Default value" means give the field the value if it doesn't have one. If
the field has a value already, it won't be changed.
|
| =?Utf-8?B?TGF1cmE=?= replied to Douglas J. Steele on 26 May 2004 |
Ahhhh, yes, I see. Thank you for your help.
|
| Brian Kastel replied to =?Utf-8?B?TGF1cmE=?= on 25 May 2004 |
Me.CreateDate = Now
Of course, your field, CreateDate, must have an associated bound control on
the form for this to work.
|
|
Archived message: Create Date (Microsoft Access)
