Show user id on a report

[Guest]

I'm using Access to create a report with data from a SQL database.

I've tried using SUSER_SNAME, but each time the result prints as #Name?
Also, CurrentUser simply returns 'Admin' every time since I'm not using the
Access security features.

I'm new to both Access and SQL. Any help greatly appreciated.

Steve

 

[Guest]

If you want to display the network user name, then use the code at
http://www.mvps.org/access/api/api0008.htm. You can then add a text box to
your report with a control source of:
=fOSUserName()

 

[Guest]

You create a new module in your MDB and paste the function into it. Then save
the module with a name like "modAPIs". This will make the function available
in control sources, queries, code,...