Popup Report Print

[buckibooster]

I have created a report with a subreport for my database. The user selects the project for which he/she wants to see a report. Once the project is selected, the report is displayed in a popup window and maximized in the print preview layout. This allows the user to view and read the report. Once this is done, there are no buttons or menus on the screen that allows the user to send the report to a printer or file. Other than the report, there are minimize / maximize and close buttons at the top right of the window and page selection buttons at the bottom left of the window. If the user wants to print the report, they must either hit ctrl-P or right click the mouse on the screen to display a menu from which the user can select print to open a print dialog box. Is there any way to add a button or menu to the print preview that appears on the screen to make printing easier? Thanks in advance for your timely help in this matter.

 

[buckibooster]

Accessblaster:

Thanks but this doesn't really solve my problem. I'm having the report sent to the screen in the print preview layout to allow my user to read through it on the screen in lieu of or prior to sending it to a printer. In other words, they can look it over and decide whether they want to print it out. Having a message popup asking them if they want to print it out defeats this purpose by blocking the screen with a message. Doing the same thing as they close the print preview requires them to know that the close box at the top right is for that purpose. I want to know if I can place buttons or a menu to close as well as print the report? I will use your suggestion as a fallback position while still looking for the solution I really want.

 

[theserginhus]

I inserted a button on my report and added this piece of code on the ON CLICK:
Private Sub Command10_Click()
DoCmd.RunCommand acCmdPrintSelection
End Sub

Hope it helps!

 

[theserginhus]

BTW, don't forget to set the button to SHOWN ON SCREEN ONLY, or it will print too.

 

[buckibooster]

theserginhus:

Thanks for you response. I do have one question, however. How did you get the button you created to show up in PrintPreview layout?