Retrieve WinNT login ID?

[Hafeez Esmail]

In my database, the user has the option to export a table
(in excel format cause that's what they're used to).

DoCmd.OutputTo acOutputQuery, "qryCustomMade", _
acFormatXLS, "C:\WINNT\Profiles\" & strUsrId & _
"\Desktop\CustomQuery.xls"

Where strUsrId is a string variable containing the log in
ID he/she uses when loggin into WINNT. This way I don't
have to ask them to type it in.

Thanks!
Hafeez Esmail

 

[Bruce M. Thompson]

In my database, the user has the option to export a table

(in excel format cause that's what they're used to).

DoCmd.OutputTo acOutputQuery, "qryCustomMade", _
acFormatXLS, "C:\WINNT\Profiles\" & strUsrId & _
"\Desktop\CustomQuery.xls"

Where strUsrId is a string variable containing the log in
ID he/she uses when loggin into WINNT. This way I don't
have to ask them to type it in.

See if this works in NT:

API: Get Login name
http://www.mvps.org/access/api/api0008.htm