Solved Macro to print only first page in report (1 Viewer)

saledo2000

Registered User.
Local time
Today, 20:58
Joined
Jan 21, 2013
Messages
94
Hi everyone,
how to create macro to print preview and print only first page in access report. Could anyone help on this.
thank you
 

theDBguy

I’m here to help
Staff member
Local time
Today, 13:58
Joined
Oct 29, 2018
Messages
21,358
Hi. Since I don't use macros, I am not sure if there's an equivalent command to DoCmd.PrintOut.
 

Gasman

Enthusiastic Amateur
Local time
Today, 20:58
Joined
Sep 21, 2011
Messages
14,047
Last edited:

Uncle Gizmo

Nifty Access Guy
Staff member
Local time
Today, 20:58
Joined
Jul 9, 2003
Messages
16,245
I found this and wondered if it might be serviceable:-

 

Uncle Gizmo

Nifty Access Guy
Staff member
Local time
Today, 20:58
Joined
Jul 9, 2003
Messages
16,245
This looks good:-


See:-

Code:
DoCmd.SelectObject acReport, "MyReport", True
DoCmd.PrintOut acPages, 1, 1
 

saledo2000

Registered User.
Local time
Today, 20:58
Joined
Jan 21, 2013
Messages
94
@theDBguy Most of the time when people say macro, they mean VBA, just using an Excel expression. I could be wrong though? :)

Would you believe, Google has already found this thread. :D

https://www.google.com/search?q=pri...9i57j69i60.10687j0j4&sourceid=chrome&ie=UTF-8


And if it does have to be an Access macro

https://support.office.com/en-gb/article/printout-macro-action-44b8569c-926d-45d6-ba6b-beea5c801750
Thank you all for your answer. I have managed to create Macro PrintOut. Could not see that option because I did not press Show all action in Macro design view. Thanks again
 

theDBguy

I’m here to help
Staff member
Local time
Today, 13:58
Joined
Oct 29, 2018
Messages
21,358
Thank you all for your answer. I have managed to create Macro PrintOut. Could not see that option because I did not press Show all action in Macro design view. Thanks again
Hi. Congratulations! Good luck with your project.
 

Users who are viewing this thread

Top Bottom