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

[ghudson]

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 around but found nothing. Anyone have any VBA suggestions?

Thanks in advance for your help!

 

[boblarson]

Look into DoCmd.PrintOut.

 

[gemma-the-husky]

can you not open in preview mode - then let the user decide what he wants.

 

[ghudson]

When using the below code I am gettting the error "This action cannot be carried out while processing a form or report event".

DoCmd.PrintOut acPages, 1, 1

What event of the report should this code be in?

 

[ghudson]

can you not open in preview mode - then let the user decide what he wants.

No I cannot. The report is being either emailed or saved to the network. All the user does is click a button and choose the location number to filter the report on. I am trying to avoid making two copies of the report, one to print both pages and the other to only print page 1.

 

[boblarson]

can you not open in preview mode - then let the user decide what he wants.

In some circumstances you may want to print it directly without user intervention. I give you an example. I built a POS system for a retail establishment a few years ago. They had a form which had the purchases there where they had entered everything. They just had to click the RECEIPT button to print a receipt. They didn't want, or need to preview it, they just needed it to print two copies which I had it do.

So there are times where you need a print but do not want user intervention. And I think this is one of those cases. So, the PrintOut command should work as you open the report and then use printout but I think you can open the report hidden so you don't have to see it in order to print. I could be wrong there but that's my thought.

 

[boblarson]

When using the below code I am gettting the error "This action cannot be carried out while processing a form or report event".

DoCmd.PrintOut acPages, 2, 2

What event of the report should this code be in?

It doesn't go in an event of the report. You use it after opening it in acViewPreview but with the window mode of acHidden.

 

[ghudson]

It doesn't go in an event of the report. You use it after opening it in acViewPreview but with the window mode of acHidden.

Well this code does allow me to externally call it and only print page 1 of the report and the code within the report is working so the user can key which location they want to report filtered on. But I wish I could put the print code within the report so that I could use an IF to determine if I want only page 1 printed or print all pages of the report based on which form is opened when the report is called.

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

Thanks for your help!

 

[boblarson]

Set a variable and use that for this code.