counter?

D

Dean Allen

Is there a way to track how many times and possibly the
user who triggers a certain messagebox? We have a secured
db and certain people try to do some stuff they are not
supposed to we figured it out and now have a msgBox in
place i was just wondering if there was a counter to see
how many times it is triggered, and if we can also see who
is doing it?

Thanks
Dean
 
J

Jim/Chris

In the code that triggers the msgbox add a new record to a
new MSGBOXLOG table with username(CurrentUser()), date and
time.
 
J

Jim/Chris

I would create a append query with the fields
username(CurrentUser()), date and time. The code to run
the query
DoCmd.OpenQuery "QueryName", acNormal, acEdit

Jim
 
Top