Recording UserName Login

[Moonsitter53]

Hi...new here and this is my first question...of many to come i would say
We are in the process of creating a Database for work... so far no problems there... My question is as follows

We have a Local Network at the office (or will have very shortly) and there will be many users of the Database, what we would like to happen is...when they login to the Network... and open Access to use the Database...(which holds Client information) the Database will


recognize who the User of the computer is and put that name into a field on a number of forms...UserName.
Can anyone tell me how that is done.
Thanks in advance for any help at all

[pbaldy]

A commonly used method to get the name:

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

I call it once when the database opens and store it someplace (hidden textbox, global variable, etc).