Solved

Generate page numbers across multiple reports

Posted on 2009-05-18
3
281 Views
Last Modified: 2012-05-07
I have a set of reports that all get printed at once. I'd like to be able to print consecutive page number on the reports as if it were one big report. Any ideas?
0
Comment
Question by:myndwire
3 Comments
 
LVL 46

Accepted Solution

by:
tbsgadi earned 500 total points
Comment Utility
Hi myndwire,

You can make an unbound master report with  all your reports as Subreports



Gary
0
 
LVL 2

Expert Comment

by:krishrr
Comment Utility
In the page Footer Section of the report, create a text box and assign the following value in control source

="Page " & [Page] & " / " & [Pages]
0
 
LVL 57

Expert Comment

by:Jim Dettman (Microsoft MVP/ EE MVE)
Comment Utility
There is nothing in Access to handle this.  You can do it, but you need to do all the work yourself using unbound text controls and a table or global variable to store the page count.  Here I'm going to use a global variable.
 In the page footers OnFormat event of each report, set the unbound text control do:
  Me![<myPageControlName>] = glngReportPageCount + 1

and in the page footer OnPrint event, do:
glngReportPageCount = glngReportPageCount  + 1
  Do that in each report.   If you want page # X of Y in each report, then that is quite a bit more complex.
JimD.
0

Featured Post

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now