Audit Tracking - Users

Hiya,

Basically I have 2 tables tblEmployee and tblDetails. My database is a
shipping database that tracks all the freight in the warehouse.
Records are added by the guys in the warehouse and then edited by
staff in the office, therefore there will be multiple users of this
database. Need to devise somesort of tracking which records which user
has edited the record and what changes he/she has made. I have found a
great example which you have to add a field in tblDetails and set it
to memo and then attach some code in the beforeupdate event in the
form. This works really well but when you make amendments to the
record it always says user: Admin. How do you set up multiple users so
that it might say User: Warehouse, or User: Gemma etc...?

Fiona

You can use an API call to Windows to get the user name (i.e. who is
currently logged in):
http://allenbrowne.com/ser-53code.ht...etworkUserName

--
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.

wrote in message
...

Basically I have 2 tables tblEmployee and tblDetails. My database is a
shipping database that tracks all the freight in the warehouse.
Records are added by the guys in the warehouse and then edited by
staff in the office, therefore there will be multiple users of this
database. Need to devise somesort of tracking which records which user
has edited the record and what changes he/she has made. I have found a
great example which you have to add a field in tblDetails and set it
to memo and then attach some code in the beforeupdate event in the
form. This works really well but when you make amendments to the
record it always says user: Admin. How do you set up multiple users so
that it might say User: Warehouse, or User: Gemma etc...?

Fiona

Allen's code for getting get work user name works lovely. I can say that i
personally use it and it grabs the login and timestamps and lets you know if
its an edit insert or delete. Thanks for all your helpfull posts Allen

"Allen Browne" wrote:

You can use an API call to Windows to get the user name (i.e. who is
currently logged in):
http://allenbrowne.com/ser-53code.ht...etworkUserName

--
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.

wrote in message
...

Basically I have 2 tables tblEmployee and tblDetails. My database is a
shipping database that tracks all the freight in the warehouse.
Records are added by the guys in the warehouse and then edited by
staff in the office, therefore there will be multiple users of this
database. Need to devise somesort of tracking which records which user
has edited the record and what changes he/she has made. I have found a
great example which you have to add a field in tblDetails and set it
to memo and then attach some code in the beforeupdate event in the
form. This works really well but when you make amendments to the
record it always says user: Admin. How do you set up multiple users so
that it might say User: Warehouse, or User: Gemma etc...?

Fiona

Feedback appreciated.

I assume you were talking about this article:
Audit Trail - Log changes at the record level
at:
http://allenbrowne.com/AppAudit.html

--
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.

"scott04" wrote in message
...
Allen's code for getting get work user name works lovely. I can say that
i
personally use it and it grabs the login and timestamps and lets you know
if
its an edit insert or delete. Thanks for all your helpfull posts Allen

"Allen Browne" wrote:

You can use an API call to Windows to get the user name (i.e. who is
currently logged in):
http://allenbrowne.com/ser-53code.ht...etworkUserName

Yes that is the article

"Allen Browne" wrote:

Feedback appreciated.

I assume you were talking about this article:
Audit Trail - Log changes at the record level
at:
http://allenbrowne.com/AppAudit.html

--
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.

"scott04" wrote in message
...
Allen's code for getting get work user name works lovely. I can say that
i
personally use it and it grabs the login and timestamps and lets you know
if
its an edit insert or delete. Thanks for all your helpfull posts Allen

"Allen Browne" wrote:

You can use an API call to Windows to get the user name (i.e. who is
currently logged in):
http://allenbrowne.com/ser-53code.ht...etworkUserName