SpaceCoastLife
asked on
Renumbering pages on an Access 2002 report
I have an Access 2002 report that generally runs around 40 to 50 pages. Within those pages there is a high level grouping. I have a user that would like to collate and staple these reports, however, their printer doesn't seem to handle it properly becuase the report page numbers run from 1 of 50 to 50 of 50. I would like to know if there is a way in code to restart the numbering of the pages for each group so instead of it running 1 to 50, it runs 1 to 10 five times for example.
I recommend this method: Reset page numbers for each group in a report
and just to make sure the bases are covered:
How to reset the page number and the total page count for each group in a Microsoft Access report
http://support.microsoft.com/kb/841779
In case you want to do "Page X of Y" for each group where Y is the number of pages per group.
Jim.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If the printer has the ability to staple groups then JeffCoachman suggestion is the way to go. I have had good luck doing that with sever different printers. The key is that each group is sent as a separated print job. This is done by send each group as a separate report. If they are separate report then page number can be handle with the standard page numbering.
ASKER
Because of the need to collate and staple they have to be sent as separate jobs. Thanks much for the help!
Thanks,
This is a pleasant surprise because my post was just a shot in the dark because you mentioned "collation"
The other links the other Experts posted are also great resources.
The other reason I posted this was because of what I encountered a while ago.
While spending quite some time coding that crazy page numbering scheme:
Page 1 of 2 for Group 1, out of 3 groups and 14 total Report pages
Page 2 of 2 for Group 1, out of 3 groups and 14 total Report pages
...The client asked if it might be faster to just print each group individually.
This way no custom coding or report modifications would be needed.
(Yes, I still had to create a query of only customers with orders, and loop it, ...but this was all on the calling form)
As always, the benefit of questions like this is to explore all the options.
I have no issue with you deciding to split the points...
;-)
JeffCoachman
This is a pleasant surprise because my post was just a shot in the dark because you mentioned "collation"
The other links the other Experts posted are also great resources.
The other reason I posted this was because of what I encountered a while ago.
While spending quite some time coding that crazy page numbering scheme:
Page 1 of 2 for Group 1, out of 3 groups and 14 total Report pages
Page 2 of 2 for Group 1, out of 3 groups and 14 total Report pages
...The client asked if it might be faster to just print each group individually.
This way no custom coding or report modifications would be needed.
(Yes, I still had to create a query of only customers with orders, and loop it, ...but this was all on the calling form)
As always, the benefit of questions like this is to explore all the options.
I have no issue with you deciding to split the points...
;-)
JeffCoachman
http://access.mvps.org/access/reports/rpt0013.htm