Convert user name to actual name? 1

[bdmangum]

Howdy!

I have a database which I am currently building. The people I'm building it for would like to see who uses the database. Thus I inserted a tracking method for each entry. I currently track the user by using the Environ("USERNAME") command. The people I'm building this for would like the username converted to the actual person's name. Similar to the way Outlook converts the username to the name when sending an email.

I have no idea how to accomplish this request. Is this possible? If so, what commands are used?

TIA

BD

 

[SkipVought]

Hi,

Maybe you have an Employee Table, containing UID and NAME?

Skip,

_{To be safe on the [red]FOURTH[/red],
Don't take a [red]FIFTH[/red] on the [red]THIRD[/red]
Or you might not come [red]FORTH[/red] on the [red]FIFTH[/red]
[red][highlight blue]FORTH[/highlight][/red][white][highlight red]WITH[/highlight][/white]}

 

[bdmangum]

I thought about that. The problem is if new users begin using the database they won't be in the table I made during development. The people whom I'm building will not like having to go update the table anytime someone new uses the system.

My company uses a Windows network where everyone is assigned a seven letter unique userID. Other Office programs such as Outlook can somehow translate the userID into the person's name. I'm not sure how this is accomplished. Is Outlook connecting to a network database with the names? If so, is there an easy way to access this?

 

[SkipVought]

Your the developer. Find out.

Skip,

_{To be safe on the [red]FOURTH[/red],
Don't take a [red]FIFTH[/red] on the [red]THIRD[/red]
Or you might not come [red]FORTH[/red] on the [red]FIFTH[/red]
[red][highlight blue]FORTH[/highlight][/red][white][highlight red]WITH[/highlight][/white]}

 

[bdmangum]

I'll ask around Skip. My thought was there may be some command which does what I need and I just didn't know about it.

 

[SkipVought]

No network know my actual name. It must be associated with the key value in some table.

Skip,

_{To be safe on the [red]FOURTH[/red],
Don't take a [red]FIFTH[/red] on the [red]THIRD[/red]
Or you might not come [red]FORTH[/red] on the [red]FIFTH[/red]
[red][highlight blue]FORTH[/highlight][/red][white][highlight red]WITH[/highlight][/white]}

 

[bdmangum]

Makes sense. So the table must be checked upon selecting the "Check Names" button or upon sending the message. It's typically at that point the names are converted. I guess need find out what table is being checked.

 

[WalkerEvans]

Check out the thread labeled "Merge Info from Active Directory to Word 2003" dated 4 July 2007. I think it may solve your problem.

----------------------------------------------------------------------------------
"A committee is a life form with six or more legs and no brain." -- L. Long

 

[CautionMP]

bdmangum,
Windows means the domain is probably controlled by Active Directory.
[tab]thread705-1230097

Hope this helps,
CMP

[small]For the best results do what I'm thinking, not what I'm saying.[/small]
(GMT-07:00) Mountain Time (US & Canada)

 

[bdmangum]

Thanks guys for the posts.

CMP,

In your GetObject command does the WinNT need to be replaced by the name of the network my office runs? When I run the code with WinNT I get an error saying the user could not be found. Is there something I need to change?

Thanks,
BD

 

[CautionMP]

bdmangum,
No but you may have to substitute the Domain name for the Computer name.

Some other useful ADS stuff:

[tab][URL unfurl="true"]www.15Seconds.com > Add to Your ADSI Code Library[/url]

Hope this helps,
CMP

[small]For the best results do what I'm thinking, not what I'm saying.[/small]
(GMT-07:00) Mountain Time (US & Canada)