To control Numbering of Page in Report

[Frank Dulk]

I have a report with break - we say, for Department.
To each new Department, the customer wants that you/he/she is not just
initiate a new page, but also that the numbering of the pages is restarted.
And doesn't just want page 1, 2, etc., but page 1 of 2, 2 of 2,...
I didn't get to find a property that feels the total number of pages in a
section.

I outlined the thing applying a filter in the report and printing a report
for each Department. When I want to print several Departments, I make a loop
of commands OpenReport (of course there I don't get to do Preview, I only
get to do printing direct; Preview only exhibits the first report...).

But now the Customer is making electronic documentation, through .PDF.

And with my process, it is difficult, because it generates " trocentos "
files .PDF.

But if I only generate a file, it comes back the blessed problem from
numbering the pages...

How to do " Page 1 of so much ", being " so much " the number of pages of
the section, and not of the report

 

[Marshall Barton]

I have a report with break - we say, for Department.
To each new Department, the customer wants that you/he/she is not just
initiate a new page, but also that the numbering of the pages is restarted.
And doesn't just want page 1, 2, etc., but page 1 of 2, 2 of 2,...
I didn't get to find a property that feels the total number of pages in a
section.

I outlined the thing applying a filter in the report and printing a report
for each Department. When I want to print several Departments, I make a loop
of commands OpenReport (of course there I don't get to do Preview, I only
get to do printing direct; Preview only exhibits the first report...).

But now the Customer is making electronic documentation, through .PDF.

And with my process, it is difficult, because it generates " trocentos "
files .PDF.

But if I only generate a file, it comes back the blessed problem from
numbering the pages...

How to do " Page 1 of so much ", being " so much " the number of pages of
the section, and not of the report

Here's an article that describes a way to do that:

http://www.mvps.org/access/reports/rpt0013.htm

 

[SA]

Frank:

If you need to automate output of a PDF file from an Access report, take a
look at our PDF and Mail Library for Access. Its quite flexible and will
allow you to specify file paths and names in code with very little VBA.

You'll find it on our web