Report ID

  • Thread starter Thread starter dbl
  • Start date Start date
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
 
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
 
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.
 
Back
Top