counter?

  • Thread starter Thread starter Dean Allen
  • Start date Start date
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
 
In the code that triggers the msgbox add a new record to a
new MSGBOXLOG table with username(CurrentUser()), date and
time.
 
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
 
Back
Top