I have a DB (Access 2007) set up so that users do not have access to the Menus or ribbon.
On the Switchboard I have an option button which opens a report in Print Preview mode, as well as a small form (Print Dialog form) relevant to the previewed report with Buttons “OK”, which gives the user an option to Print (sends straight to default printer), or “Close Report” which Cancels (closes the report preview and the small Form).
The code for the actions for the “OK” button are as shown below:
[Private Sub Print_Reports_Click()
Dim ReportDest As String
ReportDest = acNormal
'Hide the Report Print Dialog
Forms![f_PrintDialog-WaitList].Visible = False
' Destination is printer
DoCmd.OpenReport "r_WaitList", ReportDest, , , acWindowNormal
' Re-opens dialog box
Forms![f_PrintDialog-WaitList].Visible = True
End Sub]
This works well to Print to the default printer.
What I want to do is the have the Printer Dialog Box show so that users can select a choice of printer, or select which page/pages to print.
What do I need to include, what do I need to change and where do I need to put it?
Any help appreciated.
Many thanks.