UserName query

[laspates]

I have created an Access database which accepts submitted information from two InfoPath forms. I'm trying to create a field in my database which will automatically capture the user name upon submission. I've suceessfully done it with the date, using the =Now() function, but I can't figure out how to capture the user name.

Suggestions?

l.a.spates

 

[PHV]

The windows (not 9x) network login name: Environ("USERNAME")
The secured database logged user: Application.CurrentUser

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[laspates]

Would you be able to elaborate slightly? I'm a new, self-taught user. I'm doing plenty of reasearch, too....

Thanks,
l.a.spates

 

[dhookom]

You can't set a default in a table/field definition of the user name. You would need to enter the default into a control on a form.

PH pointed out two different definitions for "User Name". You didn't specify which one you want to use. I actually prefer the API at

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

over the ENVIRON() function.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]