Report ID

D

dbl

Hi is it possible to have the user ID printed on each report that a user
generates? Would it be possible for them to enter the ID when they open the
db at start up rather that inputting it before each report is printed?

Any help or idea's would be very much appreciated.

Bob
 
R

Rick Brandt

dbl said:
Hi is it possible to have the user ID printed on each report that a
user generates? Would it be possible for them to enter the ID when
they open the db at start up rather that inputting it before each
report is printed?

Any help or idea's would be very much appreciated.
Click to expand...

Just open a small form at startup where they enter their user name and press
[OK]. Have the OK button hide the form rather than close it. Now you can
refer to that entry in the form anyplace in your app.

If their Windows login name is good enough or if you don't mind maintaining
a two field table to match login names with actual names, then you can use
the code at the link below to grab the login name without having to prompt
them.

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

Rick B

If you use User-Level Security, then the user will be forced to log in to
your database. You can then put their userid on your reports, forms,
queries, etc using the following...

=CurrentUser()

This will allow you to easily timestamp records, track changes, etc.

It will also let you secure the objects in your database.
 
Top