A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

"first page number"



 
 
Thread Tools Display Modes
  #1  
Old April 14th, 2005, 09:27 PM
RobertSMS
external usenet poster
 
Posts: n/a
Default "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  
Old April 15th, 2005, 12:33 AM
Marshall Barton
external usenet poster
 
Posts: n/a
Default

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  
Old April 15th, 2005, 12:55 PM
RobertSMS
external usenet poster
 
Posts: n/a
Default

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  
Old April 15th, 2005, 03:54 PM
Marshall Barton
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 06:02 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.