Permit Reports PrintPreview, but prevent printing in some case

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to prevent certain user from printing reports in Access, base on
a value (UserAccess: 1=ok, 0=Noprint), but would like to let the user see the
reports in print preview in all case, is there a way to do that??? I cant
find any event that triggers when you use the print button in the toolbar or
the File-Print in the menu so I can cancel the printing in VBA?? thanks.
 
As previously mentioned in these groups. There is no absolute way to do
this. You could make it difficult by removing buttons and changing menus,
but the user can always get the data. They could copy the screen and paste
it into Paint (for example).

This assumes you are concerned with them capturing data they should not give
out or retain.

If you just want to make it hard for the honest folks to accidentally print
it, then there are ways to do so. In addition to changing menus and
buttons, you could force the report to print ot a specified network printer
(while in page setup in design view), then rename or remove that printer.
This would not change from one user to the ne3xt though.

In short, the Windows environment makes it easy to send items to the
printer. This is independent of the application you are using.
 
No, but there are many posts out there on custom menus and toolbars. The
help fiel should also cover that.

Rick B
 
Back
Top