 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / May 2007Page numbers for groups
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 a report which is grouped on individual names. It lists > inventory items in their care. [quoted text clipped - 7 lines] > > Robin Chapple Thanks Mike. Looks complicated but I'll give it a try. Robin >Robin, >I'm not sure if I understand your question. [quoted text clipped - 24 lines] >> >> 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 >Thanks Mike. > [quoted text clipped - 30 lines] >>> >>> Robin Chapple 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 > I have now added the sub to the code. > [quoted text clipped - 43 lines] > >>> > >>> Robin Chapple Mike, I am using Access 2002 and I also needed that "SECTION" added to the code. All is well. Robin >Robin, > [quoted text clipped - 63 lines] >> >>> >> >>> Robin Chapple Glad I could help. > Mike, > [quoted text clipped - 72 lines] > >> >>> > >> >>> Robin Chapple 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. > [quoted text clipped - 78 lines] > > >> >>> > > >> >>> Robin Chapple 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]", [quoted text clipped - 84 lines] > > > >> >>> > > > >> >>> Robin Chapple |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.