I have a need to print username

[Kamy]

I have a need to print the username in report,
Can someone tell me how to do so?

Thank you in advance,
-Kamy

 

[Van T. Dinh]

Access user or Windows user?

For Access user:

Application.CurrentUser

For Windows user (LogOnID) , see:

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

 

[Kamy]

Dinh,

I am doing sql server authentication, directly
from the server.

Upon launch default form comes up, user chooses
to open one of the few forms, then thru' Access,
he is asked to login and this login is sql server
valid login.

This is validated against sql server.
I would like to retrieve the user information logged
on this way.

Thank you,
Kamy

 

[Van T. Dinh]

In summary: You need the SQLServer Login (using SQL Server authentication),
not Access or Windows?

If this is the case, check CURRENT_USER in SQL2K B.O.L.