Resetting report page numbers

[Guest]

Hi,

I followed the instructions below on how to set the starting page number of
a report. However, the page number is now appearing as a static number on my
report (ie. I want the 3-page report to start at page 6..but every page now
reads page 6 instead of page 6, page 7, page 8)...what did I do wrong?

Thanks,
Yvette

INSTRUCTIONS FROM MICROSOFT:

Do one of the following:

If the page number is located in the page header (page header: Used to
display a title, column headings, dates, or page numbers at the top of every
page in a form or report. In a form, the page header appears only when you
print the form.), use the following values for the SetValue action arguments
(action argument: Additional information required by some macro actions. For
example, the object affected by the action or special conditions under which
the action is carried out.):

Item: [Page] and Expression: 0

If the page number is located in the page footer (page footer: Used to
display page summaries, dates, or page numbers at the bottom of every page in
a form or report. In a form, the page footer appears only when you print the
form.), use the following values for the SetValue action arguments:

Item: [Page] and Expression: 1

Save and close the macro.
Open the report in Design view (Design view: A window that shows the design
of these database objects: tables, queries, forms, reports, macros, and data
access pages. In Design view, you can create new database objects and modify
the design of existing ones.).
Add a text box to show page numbers in the page header or footer.

Do one of the following:
If the page number appears in the page header, set the ForceNewPage property
of the first-level group header (group header: Used to place information,
such as group name or group total, at the beginning of a group of records.)
to Before Section and the OnFormat property of the first-level group footer
(group footer: Used to place information, such as group name or group total,
at the end of a group of records.) to the name of the macro you created in
step 1.

If the page number appears in the page footer, set the OnFormat property of
the first-level group header to the name of the macro you created in step 1
and the ForceNewPage property of the first-level group footer to After
Section.

 

[fredg]

Hi,

I followed the instructions below on how to set the starting page number of
a report. However, the page number is now appearing as a static number on my
report (ie. I want the 3-page report to start at page 6..but every page now
reads page 6 instead of page 6, page 7, page 8)...what did I do wrong?

Thanks,
Yvette

INSTRUCTIONS FROM MICROSOFT:

Do one of the following:

If the page number is located in the page header (page header: Used to
display a title, column headings, dates, or page numbers at the top of every
page in a form or report. In a form, the page header appears only when you
print the form.), use the following values for the SetValue action arguments
(action argument: Additional information required by some macro actions. For
example, the object affected by the action or special conditions under which
the action is carried out.):

Item: [Page] and Expression: 0

If the page number is located in the page footer (page footer: Used to
display page summaries, dates, or page numbers at the bottom of every page in
a form or report. In a form, the page footer appears only when you print the
form.), use the following values for the SetValue action arguments:

Item: [Page] and Expression: 1

Save and close the macro.
Open the report in Design view (Design view: A window that shows the design
of these database objects: tables, queries, forms, reports, macros, and data
access pages. In Design view, you can create new database objects and modify
the design of existing ones.).
Add a text box to show page numbers in the page header or footer.

Do one of the following:
If the page number appears in the page header, set the ForceNewPage property
of the first-level group header (group header: Used to place information,
such as group name or group total, at the beginning of a group of records.)
to Before Section and the OnFormat property of the first-level group footer
(group footer: Used to place information, such as group name or group total,
at the end of a group of records.) to the name of the macro you created in
step 1.

If the page number appears in the page footer, set the OnFormat property of
the first-level group header to the name of the macro you created in step 1
and the ForceNewPage property of the first-level group footer to After
Section.

Your including the Microsoft instructions only tells us what Microsoft
says, it doesn't tell us what YOU DID.

Copy and paste the code directly from your report. Tell us what
section the code is placed in, i.e. Report Header Format, Page Header
format, etc. Give us an example of what you wish the finished text to
look like, i.e. "Page 6 of 12" or just "Page 6".
Then we'll have something useful to go by.

 

[Guest]

Your email triggered an idea -- I used the Report Header/Footer and the
problem is fixed. Thanks!

Hi,

I followed the instructions below on how to set the starting page number of
a report. However, the page number is now appearing as a static number on my
report (ie. I want the 3-page report to start at page 6..but every page now
reads page 6 instead of page 6, page 7, page 8)...what did I do wrong?

Thanks,
Yvette

INSTRUCTIONS FROM MICROSOFT:

Do one of the following:

If the page number is located in the page header (page header: Used to
display a title, column headings, dates, or page numbers at the top of every
page in a form or report. In a form, the page header appears only when you
print the form.), use the following values for the SetValue action arguments
(action argument: Additional information required by some macro actions. For
example, the object affected by the action or special conditions under which
the action is carried out.):

Item: [Page] and Expression: 0

If the page number is located in the page footer (page footer: Used to
display page summaries, dates, or page numbers at the bottom of every page in
a form or report. In a form, the page footer appears only when you print the
form.), use the following values for the SetValue action arguments:

Item: [Page] and Expression: 1

Save and close the macro.
Open the report in Design view (Design view: A window that shows the design
of these database objects: tables, queries, forms, reports, macros, and data
access pages. In Design view, you can create new database objects and modify
the design of existing ones.).
Add a text box to show page numbers in the page header or footer.

Do one of the following:
If the page number appears in the page header, set the ForceNewPage property
of the first-level group header (group header: Used to place information,
such as group name or group total, at the beginning of a group of records.)
to Before Section and the OnFormat property of the first-level group footer
(group footer: Used to place information, such as group name or group total,
at the end of a group of records.) to the name of the macro you created in
step 1.

If the page number appears in the page footer, set the OnFormat property of
the first-level group header to the name of the macro you created in step 1
and the ForceNewPage property of the first-level group footer to After
Section.

Your including the Microsoft instructions only tells us what Microsoft
says, it doesn't tell us what YOU DID.

Copy and paste the code directly from your report. Tell us what
section the code is placed in, i.e. Report Header Format, Page Header
format, etc. Give us an example of what you wish the finished text to
look like, i.e. "Page 6 of 12" or just "Page 6".
Then we'll have something useful to go by.