allen browne ajbFieldLevel

[David]

Hi All,

Hi, I'm new to Access/VB coding and had a question about some code written
by Allen Browne - FOUND HERE http://allenbrowne.com/ser-55.html

I'm using your Module that he wrote called ajbFieldLevel. (In Access 2003/07)

First off I'd like to say WOW!, I love this code! It works great!!!!

My only problem is this:

In the Module "ajbFieldLevel" it contains the following Code!

'API call for the network user name.
"Private Declare Function apiGetUserName Lib "advapi32.dll" Alias
"GetUserNameA" (ByVal lpBuffer As String, nSize As Long) As Long"

This line of code calls a Windows "advapi32.dll" file which gives me (I
believe) the user that it currently logged into windows or PC Name.

However,

I am using another Module called Mod_Display_Menu found here
http://forums.databasejournal.com/showthread.php?t=50198


My question is this.........

How can I assign the "Entered By:" Field in my Forms to not be based on the
network PC Name/Account, but the account login User_id used in the
Mod_Display_Menu.

Also-

Will this work across networks? Meaning if the access database has multiple
open session would access know who modified the data based on login? using
the Mod_Display_Menu.


Thanks for taking the time in reading this and helping me out! Please let me
know if anyone has a suggestion, Thanks a lot if anyone responds!