Audit trail username

[slimjen]

Hi all, I am using Audit Trail module to track usere changes in the database..it seems to work fine but the username only captures the userid not the physical name...here's the part of the code:

Dim strUserID as String
strUserID = Environ("Username")

The userid for the users does begin with a letter but I want to capture at least their physical first name..what do I need to do pls.

[rpeare]

create a table with the username and person's name seems to be the easiest. I don't believe you can get to the actual name of the user unless their directory name contains their real name. Then you could use Environ("USERPROFILE") and strip out anything after the last \ mark to generate the actual person's name, but most larger companies would us an employee ID rather than a name. Here's a link to all the ENVIRON possibilities:

http://codevba.com/office/environ.htm#.XUhJs_JKhhE