If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Resetting report page numbers
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. |
#2
|
|||
|
|||
Resetting report page numbers
On Mon, 19 Nov 2007 11:14:03 -0800, yvette wrote:
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. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
#3
|
|||
|
|||
Resetting report page numbers
Your email triggered an idea -- I used the Report Header/Footer and the
problem is fixed. Thanks! "fredg" wrote: On Mon, 19 Nov 2007 11:14:03 -0800, yvette wrote: 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. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
Thread Tools | |
Display Modes | |
|
|