469,097 Members | 1,535 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,097 developers. It's quick & easy.

MS Access - Record creation date /time stamp and record modify date/time stamp

I have created a form and inserted the following tables:
Date Entered
Time Entered
Date Modified
Time Modified
Essentially how and where can I have these dates and times recorded so when the user creates a new record that date and time stamp is populating as well as if the user modifies the data, that date and time stamp is populationg.
Whereby if the record was created yesterday, and the user modified the record today, i would see yestaerdays date and time stamp for the date / time entered and so on for the modification date/time. Please help!!
Oct 18 '06 #1
3 16744
1,418 Expert 1GB
You need to use in your form the before update event procedure for the record

After update also possible!

There you type

me![Timestamp]= Now()

And your Field with TimeStamp is ok

Oct 27 '06 #2
8,435 Expert 8TB
For the date/time of creation, you can just set the default value of the field as Now() in the table design.
Oct 28 '06 #3
are u up to audit trail thats why you created those fields?
Nov 2 '06 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

6 posts views Thread by Andre | last post: by
1 post views Thread by davelist | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.