user id

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I searched for a way to use the network user id in a field in an access form
instead of current user(). The follwoing is the answer I found in all
related posts. Problem is I can't get it to work!! My boss inssits on this
field and I just don't know how to get it to work!! Help Please!!!
Myron

See:
http://www.mvps.org/access/api/api0008.htm
 
In Access you create a new MODULE containing the code copied from that website.
When you want to call this function, you code
Dim strUser as string
strUser = fOSUserName()

To put the value directly in a control (though I'm not sure why you would
want to), code
=fOSUserName()

- Dorian
 
I cleaned my database of all ofrmer attempts to make this work, modules,
macros ect. So, now I am supposed to copy this code into a new module again,
and call it somewhere in the properties to make it work? Is this right or am
I lost again!! Sorry about the confusion, this is new territory for me. I
am teaching myself VB but I am not anywhere close to this yet!! Please give
me some more guidance if you wouldn't mind. Thanks a bunch!!
 
Back
Top