detect user

  • Thread starter Thread starter Irene
  • Start date Start date
I

Irene

i have a system. how can i detect the user who has been change the data or
update the data? i want it keep in a table and can be a proof when something
going wrong with the data.
 
Irene said:
i have been trying this. but cant. i dont know y. what is API?
Click to expand...

Paste the code into a module and save it. You can then call it from your
form's "Before Update" event to store the result in a table:

Me.txtUserName = fOSUserName

where "txtUserName" is the name of a text box bound to the field where you
want to store the name.

Keith.
 
hi keith,

thanks for ur help! but i stil have a question. is it need test on the
server? cos i'm copy the form and the table and put in my drive C to try, but
it didn't show anything. is it need put the table in the server, then the
form in the own pc? the result wil show the computer name or "admin" if he o
she is the admin for their own pc. sorry, because i'm new to this topic. hope
u stil can continue helping me. thanks!
 
Back
Top