Obtain the Windows Network User Name

[JR_06062005]

I have created an application which allows users to export information to
Excel files on their PCs. To get to the proper location on their PC for "My
Documents", I need the user id.

If anyone knows the code for requesting the user Id, I would really
apprciate your sharing it with me. Or if you know a better solution.

Thanks.

 

[freakazeud]

Hi,
check my reply here
http://www.microsoft.com/office/com...ffice-access&lang=en&cr=US&sloc=en-us&m=1&p=1

You will find what you are looking for.
HTH
Good luck

 

[Douglas J Steele]

Actually, you don't need to know their id to find out where their My
Documents folder is located. Grab the code from
http://www.mvps.org/access/api/api0054.htm at "The Access Web" and use

fGetSpecialFolderLocation(CSIDL_PERSONAL)

to retrieve it. (This has the advantage of picking up the correct location
if they've changed where their My Documents folder is)

If you really do want to get theis Network Id, see
http://www.mvps.org/access/api/api0008.htm

 

[JR_06062005]

Thanks. It works.

Hi,
check my reply here:
http://www.microsoft.com/office/com...ffice-access&lang=en&cr=US&sloc=en-us&m=1&p=1

You will find what you are looking for.
HTH
Good luck

 

[JR_06062005]

The code works. But I do have a question. I placed the public variables on
the form object class I was using above 'Option Explicit' . But Access VB
would not allow "Public" before the constants; that is, those that were not
declared separate from the function results. Am I placing these in the
correct location? As I said, the code works.

 

[Douglas J Steele]

The code should be put in a stand-alone module, not in the module associated
with a form.

 

[JR_06062005]

It works now. I needed to copy all the code including all the declared
variables and constants outside the main function. Thank you very much.
This has been very helpful.