Page numbers for groups

[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 Chapple]

Thanks Mike.

Looks complicated but I'll give it a try.

Robin

 

[Mike Revis]

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

 

[Robin Chapple]

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

 

[Mike Revis]

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

 

[Robin Chapple]

Mike,

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

All is well.

Robin

 

[Mike Revis]

Glad I could help.

Mike,

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

All is well.

Robin

 

[Guest]

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

 

[Guest]

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?

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

Glad I could help.