By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,144 Members | 872 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,144 IT Pros & Developers. It's quick & easy.

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

P: 1
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
Share this Question
Share on Google+
3 Replies

Expert 100+
P: 1,418
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

Expert 5K+
P: 8,434
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

P: 9
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.