Re: Mr Browne's audit trail

Tech-Archive recommends: Fix windows errors by optimizing your registry

Allen,

You think "Click" event, rather than "GotFocus"? I know some controls
(labels, ...) don't contain "GotFocus" events, but the Click event won't fire
if you tab through a control, will it?

John,

Seems like a lot (I guess it depends on the number of forms and controls) of
work. Is the boss trying to assess what aspects of the application are being
used most? Or is he just a busy body?

--
Dale

email address is invalid
Please reply to newsgroup only.



"Allen Browne" wrote:

No: logging button activity would be different.

Not too difficult to do though.

1. Create a table, with fields such as this:
ID AutoNum
DocName Text name of the form where this button is
CtlName Text name of the button
ClickTime Date/Time when the button was clicked.

2. Create a function that will Execute an append query statement to add a
insert a record into the logging table. The declaration in a standard module
will be like this:
Public Function LogClick(strForm as string, strCtl As String)

3. Add a line to the Click event procedure of each button you wish to log.
If the button is named cmdPrint, you would use:
Call LogClick(Me.Name, "cmdPrint")

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"JohnE" <JohnE@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3E201B48-D9A2-4079-BAE5-4963C48B3A7C@xxxxxxxxxxxxxxxx
I have a request from the boss to track the users movement on the A2003
app.
I was thinking of using Allen Browne's audit trail since I've used before
and
it works great. But now, rather then tracking the controls and the info
going in or changing, it is the button activity that is needed. So every
form and every button on each form would be tracked.

Can Mr Browne's audit trail be modified to accomplish such an objective?
If
so, how and what would need to be modified/changed? I am a newbie to the
programming field so I'll need some guidance on this.

Thank you.
john


.

Quantcast