Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how do I place a time stamp on a record?

Status
Not open for further replies.
thepope77

thepope77

Technical User
Jul 1, 2003
26
US
Hello again:

I would like to place a time stamp on each record in a database. How do I make it so that each record has a unique time stamp? The NOW() expression updates in such a way that every time I open the database, the time and date is "NOW".

Please help. Thank you very much.

Daniel Pope
 
Sort by date Sort by votes
Set the default value of the field to Now() in the table design view.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

YoBi4Ever
  • Locked
  • Question
I would like to compute how many minutes or hours the employee left work by comparing two records
Replies
3
Views
231
dhookom
dhookom
TheresAlwaysAWay
  • Locked
  • Question
How can I make Access display a + sign in front of positive integers, just as it does - for neg? 2
Replies
8
Views
3K
TheresAlwaysAWay
TheresAlwaysAWay
lameid
  • Locked
  • Question
Execution Slowing on iterative generation of PDF's
Replies
3
Views
601
lameid
lameid
TheresAlwaysAWay
  • Locked
  • Question
Crazy question: Can anyone help me create a routine to roll 2 dice 1000x and sum them? 4
2
Replies
22
Views
4K
Andrzejek
Andrzejek
ameedoo3000
  • Question
Clear all table contents without deleting records
Replies
15
Views
614
ameedoo3000
ameedoo3000

Part and Inventory Search

Sponsor

Back
Top