Page numbers renumber with each new Client Id and Job

  • Thread starter Thread starter Barb
  • Start date Start date
B

Barb

I need help with page #'s in the page footer. I have an
invoice set up. It is grouped by Client Id and
Job #. When I put the page #'s in the page footer(since
they need to be at the bottom of the page) the page
numbers start back at 1 with each new client Id. However
I need them to start back at 1 with each new Client Id
and each new Job #. There can be multiple job #s per
customer and each would need to start at page 1 with each
new job # but again there can be multiple pages per job
within each cleint id 1,2,3 etc..
 
Barb said:
I need help with page #'s in the page footer. I have an
invoice set up. It is grouped by Client Id and
Job #. When I put the page #'s in the page footer(since
they need to be at the bottom of the page) the page
numbers start back at 1 with each new client Id. However
I need them to start back at 1 with each new Client Id
and each new Job #. There can be multiple job #s per
customer and each would need to start at page 1 with each
new job # but again there can be multiple pages per job
within each cleint id 1,2,3 etc..
Click to expand...


Whatever you're doing to get the page number to reset to 1
at the start of the Client group, should be moved to the
job# group.
 
I have as an event procedure for on print of the Client
Id & Job # combo header

Private Sub GroupHeader0_Print(Cancel As Integer,
PrintCount As Integer)
'Set page number to 1 when a new group starts
Page = 1
End Sub

However everything has page 1 even when there is multiple
pages for a given client with the same job #.

Thanks,
Barb
 
Barb said:
I have as an event procedure for on print of the Client
Id & Job # combo header

Private Sub GroupHeader0_Print(Cancel As Integer,
PrintCount As Integer)
'Set page number to 1 when a new group starts
Page = 1
End Sub

However everything has page 1 even when there is multiple
pages for a given client with the same job #.
Click to expand...


I don't understand what you mean by
"Client Id & Job # combo header"

Is it that there is one group with header?

It sort of sounds like you have the Job# group header
section's Repeat Section property set to Yes. If so, then
you can not reset the page number in the section's event
procedures because it will reset it at the start of each
page. Maybe you can find a way to use the page header
instead of repeating the group header. If you can't get
what you want that way, then you will need to create another
group on the same Field/Expression, the first one's header
can reset the page number and the lower one can be repeated.
--
Marsh
MVP [MS Access]


 
It's working. Yes the repeat section property is set to
yes. I did add another header with a group called
invoice (similar grouping as other header) and set the
page to 1 in that header. Thanks for your help.
Barb
-----Original Message-----
Barb said:
I have as an event procedure for on print of the Client
Id & Job # combo header

Private Sub GroupHeader0_Print(Cancel As Integer,
PrintCount As Integer)
'Set page number to 1 when a new group starts
Page = 1
End Sub

However everything has page 1 even when there is multiple
pages for a given client with the same job #.
Click to expand...


I don't understand what you mean by
"Client Id & Job # combo header"

Is it that there is one group with header?

It sort of sounds like you have the Job# group header
section's Repeat Section property set to Yes. If so, then
you can not reset the page number in the section's event
procedures because it will reset it at the start of each
page. Maybe you can find a way to use the page header
instead of repeating the group header. If you can't get
what you want that way, then you will need to create another
group on the same Field/Expression, the first one's header
can reset the page number and the lower one can be repeated.
--
Marsh
MVP [MS Access]


to
1
Click to expand...
.
Click to expand...
 
Back
Top