Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

print preview question

Status
Not open for further replies.

irethedo

Technical User
Feb 8, 2005
429
US
Is it possible to view a report in preview mode and then have a button on it or an option on it while it is displayed to print, change printer, or add number of copies?

Thanks for any suggestions!

 
I'm guessing that you turned off the normal toolbars? If so - create a new toolbar just for the print function, & have it set to prompt user's for their printer.

A simple function I use is:

Public Function PrintOption()
On Error GoTo PrintOption_Err:

RunCommand acCmdPrint

PrintOption_Err:
Exit Function

End Function

Then I assign that function to a macro, & then assign the macro to the toolbar button. Kind of the long way around, maybe, but it works!

Hope this helps.
 
Thanks for the suggestion...

Is it possible to just launch the "RunCommand acCmdPrint"
when the report is open for preview automatically or to create a popup with a button the launch this?


I tried to launch it after I open the form but it covers up the form and doesn't allow me to see the form to decide if I want to print it or not...

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top