Determine when Data in Table was last edited

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

Guest

Hi,

Is there a way to determine when the data in a table was last edited, via
VBA?

Thanks,

Sean
 
SM said:
Hi,

Is there a way to determine when the data in a table was last edited, via
VBA?
Click to expand...

No, there isn't.

You could add a LastUpdated field to your table, put logic in your form's
BeforeUpdate event to set that field in the record being updated, then run a
query to get the maximum LastUpdated value from your table.

If you're not using a form for your updates, then there's no way.
 
Thanks for the answer!

I was going to use a variation of the approach you suggested, but I thought
there might be some hidden table property that might contain the information!
 

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

VBA - retrieve data on last create named range from previous inserted named range 0
Find the last edit position in Text Box 1
Name in table changes 3
Refresh data in sub forms when one sub form is edited 4
Prevenatative Maintenance 4
Capture Data Change in Subform Using a table as SourceObject 2
How to export table from outlook into ms access table? 0
Determine who last modified an Excel file???? 5

Back
Top