Solved Macro to print only first page in report

[saledo2000]

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]

Hi. Since I don't use macros, I am not sure if there's an equivalent command to DoCmd.PrintOut.

 

[Gasman]

@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.

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

 

[Uncle Gizmo]

I found this and wondered if it might be serviceable:-

MS Access Print Report using VBA

I have a very VBA intensive report. When I preview it everything is great but when I print it after previewing things go wacky. I have spent many hours narrowing down the possibilities and I have

stackoverflow.com

 

[Uncle Gizmo]

And Here:-

DoCmd.PrintOut method (Access)

Office VBA reference topic

docs.microsoft.com

DoCmd.PrintOut acPages, 1, 4, , 2

 

[Uncle Gizmo]

This looks good:-

Question - How to print only page 1 of a 2 page report

Is it possible to print only page one of a two page report? I have a report that I want both pages to be printed for one instance when I send the report via DoCmd.sendobject acReport or open it via DoCmd.OpenReport but for another instance I only want page one to be printed. I have searched...

www.access-programmers.co.uk

See:-

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

 

[saledo2000]

@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.

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]

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.