If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"first page number"
Can I set a "first page number" for an Access report? More generally, I have
several different Access reports which I am going to combine into one long report for my clients. Is there a way to get all the pages numbered sequentially rather than starting back at 1 on each separate report? |
#2
|
|||
|
|||
RobertSMS wrote:
Can I set a "first page number" for an Access report? More generally, I have several different Access reports which I am going to combine into one long report for my clients. Is there a way to get all the pages numbered sequentially rather than starting back at 1 on each separate report? If at all possible, this should be done by creating a new, unbound report and adding all the other reports as subreports. If that isn't possible, you'll have to use code in each report to save it's Pages value so the next report can retrieve it and set the value of Page. -- Marsh MVP [MS Access] |
#3
|
|||
|
|||
Thanks for the tip. I haven't used subreports before, so that'll be fun to
check out how to do that. "Marshall Barton" wrote: RobertSMS wrote: Can I set a "first page number" for an Access report? More generally, I have several different Access reports which I am going to combine into one long report for my clients. Is there a way to get all the pages numbered sequentially rather than starting back at 1 on each separate report? If at all possible, this should be done by creating a new, unbound report and adding all the other reports as subreports. If that isn't possible, you'll have to use code in each report to save it's Pages value so the next report can retrieve it and set the value of Page. -- Marsh MVP [MS Access] |
#4
|
|||
|
|||
You will probably run into the differences between running
separate reports and using those same report's as subreports, so come on back if you need help with it. The most common difference is that subreports do not have Page related events or header/footer sections. This issue can be worked around in most cases, but will probably depend on the specifics of your situation. -- Marsh MVP [MS Access] RobertSMS wrote: Thanks for the tip. I haven't used subreports before, so that'll be fun to check out how to do that. RobertSMS wrote: Can I set a "first page number" for an Access report? More generally, I have several different Access reports which I am going to combine into one long report for my clients. Is there a way to get all the pages numbered sequentially rather than starting back at 1 on each separate report? "Marshall Barton" wrote: If at all possible, this should be done by creating a new, unbound report and adding all the other reports as subreports. If that isn't possible, you'll have to use code in each report to save it's Pages value so the next report can retrieve it and set the value of Page. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Need Subforms? | AccessRookie | Using Forms | 7 | April 8th, 2005 09:30 AM |
Combo Box (1st) Populating Text Box (2nd) Field | AccessRookie | Using Forms | 1 | April 6th, 2005 11:37 PM |
Cannot force page # | klam | General Discussion | 3 | October 22nd, 2004 09:59 PM |
Changing Page Numbers | Wood | General Discussion | 1 | August 14th, 2004 05:54 AM |
Comments Highlighting and Paqe Numbering | Cathy C | Page Layout | 14 | May 25th, 2004 10:52 PM |