Getting Windows Display Name

[Guest]

Does anybody know how to get the Display Name of Windows? I've tried the one
posted by Chris, but to no avail. I keep getting an error message.

Also, I've gotten the windows username, but not the Display name.
CN='display name'

Thanks

John

 

[Graham R Seach]

Display Name? Sorry, I don't understand what you mean. Can you elaborate? Do
you mean the user's full name?

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

 

[Guest]

I'm sorry, let me elaborate. With our network, the Windows login name is
firstname.lastname - I already know how to get this. But after a person is
logged in, there's a display name (you can find it at the top of the start
windows) and the format is usually "Lastname FirstName MI Title". I'm trying
to get that information for the database to fill out paperwork using the
user's title.

If you do a search for 'Windows Display Name', you'll find someone else who
wanted this, and found the answer and posted it, but it doesn't work for me.
Maybe I'm using a different type of network or something.

 

[Graham R Seach]

Attached is a text file containing a class I wrote some time ago. Copy its
contents into a new class module.

It contains methods and properties you can use to get a whole heap of info
about the current user. If you can't make head or tail of it, let me know
and I'll guide you through it.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

 

[Aaron Kempf]

SELECT SUSER_SNAME()


this works only in an Access Data Projcts but since Access Data Project is
the most popular; that is how you should do it

don't trust code from other people

 

[Guest]

Hey guy, I don't see the attachment.

sorry it took so long to reply.

 

[Graham R Seach]

Email me with your email address, and I'll send it to you.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

 

[Guest]

Hey guy,

I've tried to email you several times with no luck. My e-mail address is
(e-mail address removed). I'm still interested in learning how to do this.
Thanks

John

 

[Graham R Seach]

John,

OK, check your email.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia