Page numbers for groups

  • Thread starter Thread starter Robin Chapple
  • Start date Start date
R

Robin Chapple

I have a report which is grouped on individual names. It lists
inventory items in their care.

I have a group footer and a page number field moved from the page
footer where it worked. It does nothing in the group footer.

What is needed to get a page number in a group footer?

Thanks,

Robin Chapple
 
Robin,
I'm not sure if I understand your question.
You should be able to place the page number in a group footer.

With the group footer format property set to force new page after section I
placed the page number control in the page footer and 2 different group
footers. They all showed up.

If you are trying to reset the numbering to 1 each time the group changes
this might help.

http://www.mvps.org/access/reports/rpt0013.htm

Good luck

Mike
 
I have now added the sub to the code.

I have made the control name Me!slippages as in the code. It is in
the footer.

And I have changed Me!Salesperson to Me!Whoa which is the field name.

What do I need to do to connect the report to the code?

Thanks,.

Robin
 
Robin,

I don't know where your control slippages came from. I don't see it in the
sample code.

You have to make an unbound control named ctlGrpPages in the page footer.

You have to place the control you want to group on in the page footer. You
can set it visible property to no.

I don't know which version of Access you are working with but in my version
2000 I had to change the line "Private Sub PageFooter_Format" to "Private
Sub PageFooterSECTION_Format" Caps added for emphasis.

Hope this helps

Mike
 
Mike,

I am using Access 2002 and I also needed that "SECTION" added to the
code.

All is well.

Robin
 
Will this work in Access 2000? I have modified the macro header to include
the word "Section", but when I add the control nameas as '=[Me!ctlGrpPages]",
it comes up as unrecognizeable -- no page numbers print.

Eric
 
UPDATE: I've changed the control name to "[ctlGrpPages]" and re-confirmed
that the Page Footer event procedure is correct and being entered, but to no
avail. I'm still getting the prompt to enter a Parameter value for
"ctlGrpPages" when the report runs. Could this have something to do with
Access 2000?

Eric_G said:
Will this work in Access 2000? I have modified the macro header to include
the word "Section", but when I add the control nameas as '=[Me!ctlGrpPages]",
it comes up as unrecognizeable -- no page numbers print.

Eric

Mike Revis said:
Glad I could help.
Click to expand...
Click to expand...
 
Back
Top