Network logon

[JP Ronse]

Hi,

Some time ago, someone replied with a method to get the network logon and
used createobject. It has the same functionality as

Declare Function GetUserName Lib "advapi32.dll" Alias "GetUserNameA" _
(ByVal lpBuffer As String, nSize As Long) As Long

Can someone refresh my mind. TIA.

With kind regards,

JP

 

[joel]

You are a little bit vague. I did a google search for the following an
got lots of different answers

VBA GetUserName advapi32.dll createobjec

 

[JP Ronse]

Hi Joel,

I used the API before to show 1 sheet in a workbook to a specific network
logon. Someone showed overhere another method to do the same.

With kind regards,

JP

 

[joel]

You don't need to use createobject you can use environ() method

UserName = environ("UserName")


I'm not sure what other login username you are using that requires
createobject. Are you using an Internet Explorer and then login

 

[Barb Reinhardt]

I recently tried the environ method and it didn't work for some users. I had
to replace it with the following.

http://www.mvps.org/access/api/api0008.htm

 

[joel]

Some environmental parameters can bne different on different PCs. t
check the envirnonmental parameters go to a dos window and type SET