Re: page numbering question

Tech-Archive recommends: Fix windows errors by optimizing your registry

On Tue, 09 Jan 2007 18:58:33 GMT, Slez via AccessMonster.com wrote:

I reviewed everything. It is possibly related to your suggestion 1. When I
first read that, I immediately thought I needed a control with the following
code:
="Page " & [Page] & " of " & [Pages]

Looking back, you had stated a control that "computes [Pages] = [Pages]".
What exactly do you mean by that? I feel I have followed everything else
perfectly.

I also just realized the the Run-Time error '9' must be representing my total
number of sheets, which is 9. Does that help identify where my problem might
be?

Thanks once again!

fredg wrote:
Thanks for the reply!

[quoted text clipped - 33 lines]
4) In the code, change Me!Salesman to
Me![Name of the control used to group by]

Did you follow the other suggestions I made (Numbers 1,3, and 4)?

Without seeing what you have done, it's difficult to comment.
The code does work.

Access automatically computes the page number [Page] when you run your
report and will display it whenever you have a control source set to,
for example, = "Page " & [Page]

However, it does not automatically compute [Pages], (the total number
of pages in the entire report).
In order for it to do so, you must include [Pages] in a control on
your report. You can simply add a control =[Pages] (and make it not
visible if you don't wish to show the total number of pages, or
include it along with the page number, i.e.
="Page " & [Page] & " of " & [Pages].
Of course that tells the total number of pages in the report, (which
is not what you want).
It also forces Access to format the report twice; once to calculate
the total number of pages (and count the number of pages in your
groups), the second time to display the report.
This is necessary for you to get the number of pages in each group.

So... make sure you have added a control that calls for [Pages].
Simply add an unbound control to the page footer.
Set it's Control Source to
=[Pages]
You can make it not visible if you don't want to show the total report
page count.

Re: Run-Time error '9'
No the 9 has nothing to do with the number of pages in your report.
It means that some variable has received some value greater than it is
expecting.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
.

Quantcast