Recording Date and time of record creation

H

Hughie

I typed all imaginable statements of the subject of this post into the Help
question wizard and got no returns that even resembled the questions. Hence
I turn to you all again.

In an Access form set up to allow users to only create a new record, how can
Access record the date and time of the record creation. Thanks in advance.

BTW: Can anyone recommend a user friendly book or other help device for
learning Access? I've gone through the Online Expert video training but it
just scratched the surface.
 
R

Ricky Hicks MVP

Use the "Before Insert" event of the form to populate the date and time value
....
This event triggers when the first character is typed in a new record ...

R. Hicks
 
O

Ofer

Create a new field in the table, date time type, and in the default property
of the field in the table write Now(), so every time a record will be
inserted, the date and time of the action will be automatically inserted to
the field.
 
Top