DateModified for a form 1

[XTnCIS]

Does anyone know how to capture the DateModified for a form in Access.

I can right-click on the form name in the database window and get the correct date from the properties option.

But referencing the MSysobjects table's DateUpdate field isn't always correct.

 

[PHV]

You may try this:
CurrentProject.AllForms("yourForm").DateModified

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Remou]

This may be of interest:
ACC2000: DAO LastUpdated Property Returns Incorrect Date/Time

http://support.microsoft.com/default.aspx?scid=kb;en-us;299554

 

[Remou]

In particular:

Additionally, you may have noticed that the Database window displays the correct date and time for an object's last modification. This is because Microsoft Access uses its own internal mechanism for storing the date created and date modified, independent of the Jet database engine. Unfortunately, Microsoft Access 2000 does not currently expose this information in its object model; therefore, there is no programmatic way to get to this information in Microsoft Access 2000.