Printing reports (1 Viewer)

DanielR

Registered User.
Local time
Yesterday, 19:30
Joined
Mar 16, 2018
Messages
72
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

Registered User.
Local time
Yesterday, 19:30
Joined
Mar 16, 2018
Messages
72
How do I turn the print option for users to click on?
HELP
 

MarkK

bit cruncher
Local time
Yesterday, 19:30
Joined
Mar 17, 2004
Messages
8,178
...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

Registered User.
Local time
Yesterday, 19:30
Joined
Mar 16, 2018
Messages
72
I don't want the access window to show, just the application hence I ran it minimized!!!
 

MarkK

bit cruncher
Local time
Yesterday, 19:30
Joined
Mar 17, 2004
Messages
8,178
How do your users do anything? How do they open the report?
 

DanielR

Registered User.
Local time
Yesterday, 19:30
Joined
Mar 16, 2018
Messages
72
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

MVP / VIP
Local time
Today, 02:30
Joined
Jan 14, 2017
Messages
18,186
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

Registered User.
Local time
Yesterday, 19:30
Joined
Mar 16, 2018
Messages
72
Colin,
Thank you...I finally figured it out...works great.
 

AndrewS

Registered User.
Local time
Today, 02:30
Joined
Feb 21, 2017
Messages
30
I put a button (called btnPrint) on the report with the following code attached to it:

Code:
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

MVP / VIP
Local time
Today, 02:30
Joined
Jan 14, 2017
Messages
18,186
If you are happy using report view, that solution is fine.
My approach is based on opening the report in print preview.
 

Users who are viewing this thread

Top Bottom