View Full Version : Group Page Numbers


Deb in LA
05-01-2000, 02:18 PM
Hi everyone. I went to this web page and followed the directions, but it does not work: http://www.mvps.org/access/reports/rpt0013.htm

I have an unbound textbox in one of the group headers called "GrpPgInd" by grouping field is called "PTNum". I have replaced the code where asked for at: http://www.mvps.org/access/reports/rpt0013.htm
with these two. It does not work. Nothing shows up in the report.

The unbound txt field on my report is blank in the print preview.

The code is at the onformat event in the group header. I made sure it is saying group header_format not groupfooter_format.

In short, my report looks like this:

pageheader (nothing in here)
groupheader1 (query results the report is based on---basically address info)
detail (query results the report is based on)
groupfooter3 (subreport-rptPayments)
groupfooter2 (legal wording, grand totals)
groupfooter1 (subreport--rptLien)
pagefooter (nothing in here)

I have defined 3 groupheader/footer sections all based on PTNum.

Thanks in advance for any help regarding this issue.

Deb

Hoa Le
05-09-2000, 12:31 PM
Deb - Send me a sample Access db with the subject report and I'll take a look at it.

Check Two
09-08-2001, 02:45 AM
Bit late this reply.
The code you used does work.

What the guide didn't tell you that you need to have a text box with the control source set to the display page numbers for the whole report.

Just put a text box in the page footer and set it's control source in the expression builder to Page N of M. Found in common expresion. Then set it's visable property to no and this should work.

Happy YN
01-28-2002, 06:13 PM
Did this help for you? or have you found another solution for the pages in a group of a report? I am really stuck. my page n of m is in the page header and it works fine but in the footer it displays as page 0 of 16!!? I have set the group to renumber pages by using pagerenum macro from MS
Please reply asap -urgent!!
thanks
Happy YN

[This message has been edited by Happy YN (edited 01-28-2002).]

Rich
01-29-2002, 12:18 AM
Don't use the Macro method, you're using the code from http://www.mvps.org/access/reports/rpt0013.htm just use the normal page of page etc from the insert menu, put it in the page footer.

Happy YN
01-29-2002, 01:11 AM
Rich! You still didn't tell me what you meant by controlsource & tab
Please clkarify exact properties for text controland group header etc