How can I obtain the first and last name of the logged in user from
within VBA. I know that Environ("Username") will give the username,
but there is no such entry for the users full name.
Thanks,
~ d
Dr. Stephan Kassanke - 22 Sep 2005 16:59 GMT
> How can I obtain the first and last name of the logged in user from
> within VBA. I know that Environ("Username") will give the username,
> but there is no such entry for the users full name.
>
> Thanks,
> ~ d
http://www.mvps.org/access/api/api0066.htm (Get full name of the user
currently logged in to the system) should help you.
cheers,
Stephan
Jonathan West - 22 Sep 2005 18:34 GMT
> How can I obtain the first and last name of the logged in user from
> within VBA. I know that Environ("Username") will give the username,
> but there is no such entry for the users full name.
>
> Thanks,
> ~ d
How to get the username of the current user
http://www.word.mvps.org/FAQs/MacrosVBA/GetCurUserName.htm

Signature
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org