Last modified Date for an Access file

[Jess]

What is the vba command that yields the date when THE CODE for an access file
was modifed for the last time?

Can anybody post an example?

 

[Daniel Pineault]

Perhaps someone will say otherwise, but to my knowledge this cannot be done.
You can determine the last modified time of the mdb file itself, but when
someone edited the vba code... I do not believe this is possible.

Why? What is the end goal? Perhaps we can guide you in another way.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[Daryl S]

Jess -

Modules and forms have modified dates, but not individual pieces of code
that I know of.

 

[Jess]

Thanks

How can I know the modified date for a form, a report, and a module?

Can you post an example?

Thans

 

[NuBie via AccessMonster.com]

i'm not sure the code below will help you since as per this article
http://support.microsoft.com/kb/299554 it seems this is a known problem. not
sure if its been fixed. the article was written last June 25, 2004.

ACC2000: DAO LastUpdated Property Returns Incorrect Date/Time

Private Sub Command0_Click()
MsgBox CurrentDb.Containers("Forms").Documents("form1").LastUpdated
End Sub

Thanks

How can I know the modified date for a form, a report, and a module?

Can you post an example?

Thans

Jess -

[quoted text clipped - 5 lines]

 

[Daryl S]

Jess -

Be very careful with the system objects. Remember to back up your database
before playing with this...

SELECT MSysObjects.DateUpdate
FROM MSysObjects
WHERE (((MSysObjects.Name)="objectname"));

Put in any object name (table name, report name, etc.)