Print report directly from switchboard button? 1

[KerryL]

When a user goes to the Reports Menu from the main switchboard and clicks on one of the report selections, the report is opened up for viewing.

But I'd rather send the report directly to the printer so users cannot click on the edit button and mess around with the formatting of the report.

I assume I should assign a "Run Code" option to the menu button and create some standard VB code to print the report? Can I include options within that code? For instance, can I do a print preview first, or set the number of copies to 2, or limit the report to specific pages?

 

[WildHare]

Check the code for the buttons - the last modifier on the DoCmd.OpenReport line is probably "acPrintPreview" or something - change it to "acNormal" where ever you want to go directly to the ol' H/P...

The other stuff is a bit klunkier - but look up the OutputTo method in HELP and see if it sheds any light..


Jim Hare
"Remember, you're unique - just like everyone else"

http://www.jmhare.com

 

[Smack]

If you want a specific report based on a specific record create a prompt query and then just use a print command button.
-Smack