How to disable printing

[Linda]

I am ready to launch my database and am just going over a few small issues.
It occurred to me that I don't want users to be able to print queries, as
they will be way too long. They will have the option to export the query to
excel and can do what they want from there.

How can I disable the printing function just for queries?

Thanks!

 

[John Spencer]

Well good design practices would be that your users NEVER see a query. They
see the results of the query displayed in a form or in a report.

That would make it easier to control whether or not they could print.

I don't know of any simple way to stop users from printing the query. You
would have to remove the print items from the menu and toolbars and institute
your own procedures for printing. Plus you would have to trap the control key
sequence for printing.

So your small issue is quite a bit larger than you believe.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County