Recording the date and time when a record is modified in Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I have a data access page connected to a mdb database. Whenever user
adds or modifies a record through this page it should save the last modifed
date and time in a table so that it can be used to display in data access
page as well as in report. I saw lot of threads related to storing last
modifed date and time on forms, access projects, etc. But none of them talks
about displaying that on data access page which is connected to an mdb.

Can anyone help me on this.

Thanks
 
Update table set filed1=somevalue,
field2=somevalue....DateField=datetimevalue

Madhivanan
 

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

time stamp record without overwriting previous time 1
Access How to record date/time when specific field is modified in Access 2007 0
Date Modified for a Record 5
Record/Page Locking 2
Save or Modify a record 3
{Q} How to modify record in M Access database? 0
Maximum record size and maximum number of records 3
Stored date is not being recognised 1

Back
Top