Page numbering continued from 1st report to 2nd report

[EddyLLC]

I have two different reports but they are always printed at the same time. One is a detailed breakdown the other is a totals. I would like the page numbering to continue from one to the other. If for example the first report has 3 pages the first page of the second report would be numbered page 4.

I have the page numbe in the report header if that matters and I use the following code to run the reports:

DoCmd.OpenReport "Totals Report", acViewNormal
DoCmd.OpenReport "Details Report", acViewNormal

Any thoughts on this is greatly appreciated.

 

[Remou]

How about including the second report as a subreport in the report footer on the first report?

 

[Remou]

As a ps, there is a dedicated forum:
Microsoft: Access Reports Forum
forum703

 

[EddyLLC]

Thanks for the response. I will try to see if it works. One report already has a sub in the footer. One report already has a sub in the footer so it would be a report with sub that has a sub. That's new to me but I will give it a try.

I do have one similar question and I don't know if I should continue to use this thread or go to the Reports form. I'll try it here. Is there a limit to the number of preview screens you can open at once. It involves the same pair of reports but 4 different sets of them. The code runs through fine but when I look at the 2 preview screens open only the first pair are there. Is it possible to open more than 2 preview screens at once?

Thanks again
Eddy

 

[Remou]

Is it possible that the first two previews are hiding others? That is, have you checked under Windows on the Menu Bar? If not, is it possible that there is code to close some of the reports in the Open event, for example, of others?

 

[EddyLLC]

I checked the Windows Menu Bar and only the first two previews are open. I know it's the first two based on the data. I even did a Ctl-Alt-Del to see whats open in the Windows Task Manager. Only two were there. I check the code that generates the reports as well as the code behind the reports. There is nothing that closed them prematurely.

 

[Remou]

Re-reading your post, I think the problem may be that you can only open the same report once, even if you are using different criteria. I seem to remember that there is a code work-around for this, involving different instances of the report.