Tracking 'Actions'

[FBxiii]

Hi,

I have created a function log when a user clicks/changes a control on a
form. This is to help when debugging errors to help try and determine what a
user did to cause the error.

Is it possible to do this at application level? i.e. If user selects Open
Database from the File menu, could this be logged somehow?

Cheers,
Steve.

 

[K Dales]

Almost anything is possible... Not sure because I have not tried it, but
somewhere, somehow, Windows knows that the user made that selection - you
just need to trap it. And that might take a lot of work.

I believe that if you add a reference to the Microsoft Office object model
you will have the CommandBars collection for all your toolbars and menu bars,
and can use the CommandBarButton Click event procedure to trigger the
logging. But depending on how many actions like this you want to be able to
log you may need dozens of event procedures.

You might be able to trap them at a "lower" level by using the Windows API
and writing your own custom classes but that is getting pretty involved.
Without having actually tried it I hesitate to discuss or even recommend it.