How do I disable printing of a report

BigMr.C

Registered User.
Local time
Today, 17:28
Joined
Mar 1, 2005
Messages
14
I have a report that everyone is allowed to view on screen, but only certain people are allowed to print.
How would I go about programming this?

Thanks
 
Hope the following is useful for you.

You can create two buttons: 1 button for viewing reporto on the screen, 2nd button for printing the report. 2nd button is only visiblable or enable for certain people due to the database login name.

The VBA code as the following:

' print the report directly without preview
DoCmd.OpenReport YourReportName, Printview

' preview the report on the screen
DoCmd.OpenReport YourReportName, acViewPreview, , DateFilterStrirng
 

Users who are viewing this thread

Back
Top Bottom