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
|
|||
|
|||
Page Numbering
I have a report that when it I run it it will pull up different customer's,
how can I get the page numbering to re-number(start over) when the page comes to a different customer? -- -- Alison |
#2
|
|||
|
|||
Page Numbering
If you group by customer you can use code to restart the page numbering for
each customer: http://www.mvps.org/access/reports/rpt0013.htm For reasons I do not recall I think it is necessary to put an unbound (hidden, if you like) text box in the group footer with the ControlSource set to =[Pages]. This is in addition to the method described in the link. "alison.justice" wrote in message ... I have a report that when it I run it it will pull up different customer's, how can I get the page numbering to re-number(start over) when the page comes to a different customer? -- -- Alison |
#3
|
|||
|
|||
Page Numbering
[Pages] (hiden or not) any where in a report causes the Format event to fire
twice; the first time to get the number of pages and the second time to format the report before printing. Steve "BruceM" bamoob_at_yawhodotcalm.not wrote in message ... If you group by customer you can use code to restart the page numbering for each customer: http://www.mvps.org/access/reports/rpt0013.htm For reasons I do not recall I think it is necessary to put an unbound (hidden, if you like) text box in the group footer with the ControlSource set to =[Pages]. This is in addition to the method described in the link. "alison.justice" wrote in message ... I have a report that when it I run it it will pull up different customer's, how can I get the page numbering to re-number(start over) when the page comes to a different customer? -- -- Alison |
#4
|
|||
|
|||
Page Numbering
Thank you for the help I'll try it.
-- Alison "Steve" wrote: [Pages] (hiden or not) any where in a report causes the Format event to fire twice; the first time to get the number of pages and the second time to format the report before printing. Steve "BruceM" bamoob_at_yawhodotcalm.not wrote in message ... If you group by customer you can use code to restart the page numbering for each customer: http://www.mvps.org/access/reports/rpt0013.htm For reasons I do not recall I think it is necessary to put an unbound (hidden, if you like) text box in the group footer with the ControlSource set to =[Pages]. This is in addition to the method described in the link. "alison.justice" wrote in message ... I have a report that when it I run it it will pull up different customer's, how can I get the page numbering to re-number(start over) when the page comes to a different customer? -- -- Alison |
Thread Tools | |
Display Modes | |
|
|