Inputing Current user NT Username into a field

[djdohboy]

I have made a call Logging database for work, the only problem is that there
is an form for each member of tech staff.

This means that every time i need to update the form I have to do it 4/8
times. What I would like to do is put a bit of code into the "logged by" text
box that would capture whoever was logged on by there NT logon, and save it
into the "logged by" field when the form is saved, therefore if i have to
update the page, I only have to do it once.

Is this possible or if not, how would you surgest I go about this?

Many thanks in advance

John

 

[Daniel]

The following API will permit your to identify the currentuser's NT username

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

Then you can pass it to your form or do anything else you'd like!

 

[djdohboy]

Hi Daniel

Thanks for that info!
I have created a new module called fOSUserName as instructed by the link you
gave me, but how do i get the fOSUserNamemodule into a text box on my form?
Sorry If im being a bit dim.

Thanks

John

 

[Daniel]

For example you could create an open event for your form where you'd put code
such as

Me.txtboxname = fOSUserName

That should do the trick
--
Hope this helps,

Daniel P

Hi Daniel

Thanks for that info!
I have created a new module called fOSUserName as instructed by the link you
gave me, but how do i get the fOSUserNamemodule into a text box on my form?
Sorry If im being a bit dim.

Thanks

John