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

Adding a time stamp to a records

P: 8
I currently have a button on a form that is adding a record to a table. I would like to add a time stamp to table, which shows me when I added the new record. How do I add that to the quarie, thanks
Jun 4 '07 #1
Share this Question
Share on Google+
3 Replies


JConsulting
Expert 100+
P: 603
I currently have a button on a form that is adding a record to a table. I would like to add a time stamp to table, which shows me when I added the new record. How do I add that to the quarie, thanks
add a field to your table

make it a date time field

in it's default value property put

Now()

when a new record is generated, it will automatically put a date/time in
J
Jun 4 '07 #2

P: 8
WOW!!!

that's easy enough. Do you for see any problem with entering old dates to records already added to the table? thanks alot for all the help

add a field to your table

make it a date time field

in it's default value property put

Now()

when a new record is generated, it will automatically put a date/time in
J
Jun 6 '07 #3

JConsulting
Expert 100+
P: 603
WOW!!!

that's easy enough. Do you for see any problem with entering old dates to records already added to the table? thanks alot for all the help
no, the default only applies to new records, and can be overwritten.
Luck!
J
Jun 6 '07 #4

Post your reply

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