Reports printing

  • Thread starter Thread starter Andy
  • Start date Start date
A

Andy

Hi All,

I am really struggling with this one. I have 5 different
reports in Access that always have different number of
pages in each report. I want report 2 to start from the
page after report 1 ends and report 3 to start from the
page after report 2 ends and report 4 to start after
report 3 and so on
e.g If report 1 is page 1-15 then report 2 start on page
17 (the new report to always start with odd number page)
page 16 left blank intentionally.
and if report 2 starts from page 17 to 20 then report 3
to pickup from page 21 and so on.
Last to capture all the starting page number on table of
content page.
And at the end create one pdf document with all 5 reports
combine(I don't mind manualy if not possible to automize)
 
Andy,

For the paging:
Place an unbound text control in the page header or footer for the report
with "=1" in the Control Source property and over all in the Running Sum
property in the first report. That control will have the number of pages in
it and can be passed to a simular control in the next report.

For the pdf:
You will need a pdf creator. The cheapest I know of is pdf995.com. After
you install it, it will simply be in the list of printers you have so you
just print to it.

Hope that helps.

Nelson
 
Back
Top