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

 

[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.)