Hi!

Is there a function I can use to do this? When a user opens the database, I
want my switchboard to automatically capture the user's name to be stored in
a public variable.

Thanks, this discussion group is great and all help is greatly appreciated!
--
www.brightfuture.ca/bright
My email address can be found on my site.

Johnny Bright wrote:
> Hi!
>
> Is there a function I can use to do this? When a user opens the
> database, I want my switchboard to automatically capture the user's
> name to be stored in a public variable.
>
> Thanks, this discussion group is great and all help is greatly
> appreciated!

Example code at this link will return the Windows Login name.

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

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com