Entry Date

  • Thread starter Thread starter Abe Katz
  • Start date Start date
A

Abe Katz

Hello,
Is there a way to see the date the transaction was entered in a table?
Thanks in advance
 
On a Form? With a date field added to the table, add the field to the form
and set the default value to Date() and if you want, make it invisible. to
catch updates on existing records, add

Private Sub Form_BeforeUpdate(Cancel As Integer)
Me.dateentered.Value = Date
End Sub

Damon
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Daily Entry with multiple entries per field 0
Excel Vba to change displayed year automatically. 14
Access Updating inventory levels 0
Showing value based on another value in a form 3
Problem Using Dates in a Query 6
Forcing a date entry format of dd/mm/yyyy 1
Show null values in Query 0
Access Validation rule in MS access 2010 1

Back
Top