CODEWITHSUNDEEP
ms-accessvbams-access-2010
rohrl77
rohrl77

Reputation: 3337

How to capture form or report changes made in design view

I want to have an audit log of any change made to a form or report in design view, with the control or object manipulated, when it was done and by whom.

However, in creating this, I am stumped on the very first and most basic task, which is figuring out whether Access has a central function that would record the event of calling up a form in design view. [Hence I have no code to show for this problem yet].

What event or procedure in MS Access can I monitor (using VBA) to record when a form or report is called up in design view?

Any pointer provided is appreciated. Or alternatively if someone can tell me with certainty that this is not feasible to implement.

Upvotes: 0

Views: 159

Answers (1)

Andre
Andre

Reputation: 27634

I can tell you with certainty that this is not possible. There is no such event.

The only thing available is the "Last modified" date, which you can read e.g. from MSysObjects.DateUpdate.

To track design changes, you may want to look here:
How do you use version control with Access development?

Upvotes: 1

Related Questions