Prevent Printing in Access 2003

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kevin - 19 Dec 2007 18:16 GMT

I have an office-wide database that I want to lock down all print
capabilities. Within the AutoKeys macro, I've locked down the print shortcut
of Ctrl + P (^P). However, I recently found out someone was printing using
the hot keys of Alt + P. I discovered the Alt button is an exclamation point
(!). But when I try and disengage the Alt + P print function in the AutoKeys
macro (by using !P), I get an edit message. How do I disengage Alt + P
printing from the AutoKeys macro?

Signature

Kevin

Reply to this Message

Tom van Stiphout - 20 Dec 2007 04:08 GMT

You can't in the AutoKeys macro. The help file says as much: you can
only use a subset of what SendKeys can do.

You realize that users could also make a screendump (PrintScreen),
paste it in Word or similar, and print from there.
Or - depending on your security - run the underlying query and print
the data that way.

-Tom.

>I have an office-wide database that I want to lock down all print
>capabilities. Within the AutoKeys macro, I've locked down the print shortcut
[quoted text clipped - 3 lines]
>macro (by using !P), I get an edit message. How do I disengage Alt + P
>printing from the AutoKeys macro?

Reply to this Message

Prevent users Printing in Access 2003 - 06 Jan 2008 06:55 GMT

Kevin , how can I prevent a network user from being able to use the
file-print menu in Access 2003 , as there is a very important document I dont
want to be printed.

> I have an office-wide database that I want to lock down all print
> capabilities. Within the AutoKeys macro, I've locked down the print shortcut
[quoted text clipped - 3 lines]
> macro (by using !P), I get an edit message. How do I disengage Alt + P
> printing from the AutoKeys macro?

Reply to this Message

Tony Toews [MVP] - 06 Jan 2008 23:09 GMT

Prevent users Printing in Access 2003 <Prevent users Printing in
Access 2003@discussions.microsoft.com> wrote:

>Kevin , how can I prevent a network user from being able to use the
>file-print menu in Access 2003 , as there is a very important document I dont
>want to be printed.

Hit the Print Screen button and paste into Word. Scroll down.
Repeat.

Tony

Signature

Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

Reply to this Message