Solved

Generate page numbers across multiple reports

Posted on 2009-05-18
3
285 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 46

Accepted Solution

by:
tbsgadi earned 500 total points
ID: 24418868
Hi myndwire,

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



Gary
0
 
LVL 2

Expert Comment

by:krishrr
ID: 24419268
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
ID: 24421235
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Familiarize people with the process of utilizing SQL Server functions 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 Microsoft Ac…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

734 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