Adding ID field to a report in Access

[Guest]

I need to add a field to a report that will identify the person that printed
the report. What I would like to do is add a field that will display the
Windows login id or computer name or something related to the computer or
person printing the report. Any help would be greatly appreciated.
Thanks in advance for your help,

 

[Allen Browne]

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

After copying the code into a standard module, you can add a text box to
your report, and set its Control Source to:
=fOSUserName()

 

[krissco]

I need to add a field to a report that will identify the person that printed
the report. What I would like to do is add a field that will display the
Windows login id or computer name or something related to the computer or
person printing the report. Any help would be greatly appreciated.
Thanks in advance for your help,

Put a text box on your report with the following source:

=environ("username")


Please note, this uses an environment variable which is subject to
tampering (if your users are somewhat sophisticated). There is an API
call (no doubt someone will post it, or you can search for it) which
would eliminate the prospect of tampering.

-Kris