K
Karen
Setup: users are only allowed to see information for their assigned
region(s). Currently, for each report they select, a password dialog box
pops up and they have to enter their password. This runs a macro for that
specifc report and the filter runs from the macro. The password is the same
as the one that opens the database for them as well. This password
information is stored in the User Table There are several reports and this is
time consuming for the user. Some users have multiple regions to access.
I would like the user to be able to enter their password once,to open the
database. Any reports run will use the region information for that user. I
am not sure how to begin this filtering process. If I need to, I would like
to use macros as I am not very good with VBA coding.
region(s). Currently, for each report they select, a password dialog box
pops up and they have to enter their password. This runs a macro for that
specifc report and the filter runs from the macro. The password is the same
as the one that opens the database for them as well. This password
information is stored in the User Table There are several reports and this is
time consuming for the user. Some users have multiple regions to access.
I would like the user to be able to enter their password once,to open the
database. Any reports run will use the region information for that user. I
am not sure how to begin this filtering process. If I need to, I would like
to use macros as I am not very good with VBA coding.