disable print in A2003

[Brigitte P]

We have a report that we want to display on the screen but users should not
be able to print anything. I have fixed the menu and toolbar to prevent
printing, but how do I prevent the Windows print function CtrP from inside
Access?
I made in the past a point to educate our users to use CtrP if they lose the
print icon on the toolbar (computers not restarted for a long time has
created this problem), and now they know
Thanks for any help.
Brigitte P.

 

[tina]

you can create an AutoKeys macro, and assign a different action to Ctrl+p.
create a new macro object, and name it AutoKeys. in the macro design window,
set up the macro as follows:

MacroName: ^p
Action: Msgbox
Message: Sorry, you can't use Ctrl+P to print.
Beep: Yes
Title: REQUEST DENIED

note that the user will not be able to use Ctrl+p to print *anywhere* in
that database, though it will have no effect on other databases in Access.

hth

 

[Brigitte P]

Thanks for the detailed instructions. It worked great, and I know how to
disable certain keys in the future. I had already an AutoKeys macros to
disable the bypasse key, and I just added it on to that macro.
Brigitte

 

[tina]

you're welcome

Thanks for the detailed instructions. It worked great, and I know how to
disable certain keys in the future. I had already an AutoKeys macros to
disable the bypasse key, and I just added it on to that macro.
Brigitte