Printing reports

[DanielR]

I created an application, set the run option to minimized on the shortcut and after opening a report I have no way of allowing the user to print the report. How do I do this?

 

[DanielR]

How do I turn the print option for users to click on?
HELP

 

[MarkK]

...set the run option to minimized on the shortcut...

Have you tried setting the run option to maximized on the shortcut? Is that the problem, that the Access window is not visible?
Mark

 

[DanielR]

I don't want the access window to show, just the application hence I ran it minimized!!!

 

[MarkK]

How do your users do anything? How do they open the report?

 

[isladogs]

Have a look at my example database https://www.access-programmers.co.uk/forums/showthread.php?t=293584

This shows how an application which runs a popup form with the main application window hidden. It also demonstrates how to display the print preview ribbon whilst a report is open then hide it again when the report is closed.
That should solve your problem.

 

[MarkK]

Thanks Colin!!!

 

[DanielR]

So what you are saying is not to run the application in minimized size, make the access background invisible through code and the pop up for printing would work.

 

[isladogs]

This is what I do:
Minimize the application window (which effectively hides it)
Hide the nav pane & ribbon
Use a popup form so its floating on the desktop
Use a button to open the report in print preview and show the PP ribbon
Close the report & the ribbon is hidden again

If you look at the example in detail you should be able to see how I've done it

 

[DanielR]

Colin,
Thank you...I finally figured it out...works great.

 

[isladogs]

Excellent. Glad it's working as you wanted

 

[AndrewS]

I put a button (called btnPrint) on the report with the following code attached to it:

Private Sub btnPrint_Click()
  DoCmd.PrintOut
End Sub

It prints directly to the default printer with no opportunity for the user to change the printer, but that works for me.

 

[isladogs]

If you are happy using report view, that solution is fine.
My approach is based on opening the report in print preview.

 

[DanielR]

Thanks Colin