|
tech
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
page numbers in report restart per recordHow do I get the page numbers to restart (1 of __) for each record in a
report? Right now each record in the report is about 3 pages, which is fine, but when doing several records the first record says 1 of 6 instead of 1 of 3. Thanks. Hi Shannon,
Put your Page textbox in the footer for the record rather than the page footer. HTH -- Show quote-Larry- -- "Shannon" <Shan***@discussions.microsoft.com> wrote in message news:0251BBA4-0137-40B0-86DB-8EC5093EA15B@microsoft.com... > How do I get the page numbers to restart (1 of __) for each record in a > report? Right now each record in the report is about 3 pages, which is fine, > but when doing several records the first record says 1 of 6 instead of 1 of > 3. Thanks. Larry, I tried that, but it's still saying 3 of 5, 4 of 5, 5 of 5 after the
record. Maybe I'm missing something. Shannon Show quote "Larry Daugherty" wrote: > Hi Shannon, > > Put your Page textbox in the footer for the record rather than the page > footer. > > HTH > -- > -Larry- > -- > > "Shannon" <Shan***@discussions.microsoft.com> wrote in message > news:0251BBA4-0137-40B0-86DB-8EC5093EA15B@microsoft.com... > > How do I get the page numbers to restart (1 of __) for each record in a > > report? Right now each record in the report is about 3 pages, which is > fine, > > but when doing several records the first record says 1 of 6 instead of 1 > of > > 3. Thanks. > > > Try this link, it seems a lot simpler than what I had used in the past...
http://www.mvps.org/access/reports/rpt0013.htm Show quote "Shannon" <Shan***@discussions.microsoft.com> wrote in message news:B7A6AAC6-D020-44B6-A4CA-34082C89FB34@microsoft.com... > Larry, I tried that, but it's still saying 3 of 5, 4 of 5, 5 of 5 after > the > record. Maybe I'm missing something. Shannon > > "Larry Daugherty" wrote: > >> Hi Shannon, >> >> Put your Page textbox in the footer for the record rather than the page >> footer. >> >> HTH >> -- >> -Larry- >> -- >> >> "Shannon" <Shan***@discussions.microsoft.com> wrote in message >> news:0251BBA4-0137-40B0-86DB-8EC5093EA15B@microsoft.com... >> > How do I get the page numbers to restart (1 of __) for each record in a >> > report? Right now each record in the report is about 3 pages, which is >> fine, >> > but when doing several records the first record says 1 of 6 instead of >> > 1 >> of >> > 3. Thanks. >> >> >> Mark, I tried this, but nothing happened. I am a beginner user so I'm a
little lost with "code", but I copied and pasted and changed the Me!Salesperson to the ID for the table. I haven't grouped anything, I just want page numbers for each record, instead of all records. I appreciate the help, but I'm afraid this is way over my head. Shannon Show quote "Mark" wrote: > Try this link, it seems a lot simpler than what I had used in the past... > http://www.mvps.org/access/reports/rpt0013.htm > > > "Shannon" <Shan***@discussions.microsoft.com> wrote in message > news:B7A6AAC6-D020-44B6-A4CA-34082C89FB34@microsoft.com... > > Larry, I tried that, but it's still saying 3 of 5, 4 of 5, 5 of 5 after > > the > > record. Maybe I'm missing something. Shannon > > > > "Larry Daugherty" wrote: > > > >> Hi Shannon, > >> > >> Put your Page textbox in the footer for the record rather than the page > >> footer. > >> > >> HTH > >> -- > >> -Larry- > >> -- > >> > >> "Shannon" <Shan***@discussions.microsoft.com> wrote in message > >> news:0251BBA4-0137-40B0-86DB-8EC5093EA15B@microsoft.com... > >> > How do I get the page numbers to restart (1 of __) for each record in a > >> > report? Right now each record in the report is about 3 pages, which is > >> fine, > >> > but when doing several records the first record says 1 of 6 instead of > >> > 1 > >> of > >> > 3. Thanks. > >> > >> > >> > > > Shannon, I have used this code and it works quite well. Be sure to read the
instructions very carefully. You may have missed the instruction about placing Me!ctlGrpPages in the footer. Add an unbound text box to the footer and name it ctlGrpPages. To insert the code, in Report design view click View > Code, go to the top of the code window, delete "Option Compare Database" (since it is already in the code provided), and paste the code. The code numbers pages within a group, so unless you group your records the code has nothing on which to work. Click View > Sorting and Grouping, and group by the primary key field. See Help as needed for more information on Grouping. Check the code carefully to be sure you have replaced all of the sample control names with your actual control names. Four lines from the bottom of the code is a line that starts Me!ctlGrpPages =. Change what is in quotes on that line to alter what will appear. As the code stands it will read "Group Page 1 of 2". If you remove the word Group you will see "Page 1 of 2". Show quote "Shannon" wrote: > Mark, I tried this, but nothing happened. I am a beginner user so I'm a > little lost with "code", but I copied and pasted and changed the > Me!Salesperson to the ID for the table. I haven't grouped anything, I just > want page numbers for each record, instead of all records. I appreciate the > help, but I'm afraid this is way over my head. Shannon > > "Mark" wrote: > > > Try this link, it seems a lot simpler than what I had used in the past... > > http://www.mvps.org/access/reports/rpt0013.htm > > > > > > "Shannon" <Shan***@discussions.microsoft.com> wrote in message > > news:B7A6AAC6-D020-44B6-A4CA-34082C89FB34@microsoft.com... > > > Larry, I tried that, but it's still saying 3 of 5, 4 of 5, 5 of 5 after > > > the > > > record. Maybe I'm missing something. Shannon > > > > > > "Larry Daugherty" wrote: > > > > > >> Hi Shannon, > > >> > > >> Put your Page textbox in the footer for the record rather than the page > > >> footer. > > >> > > >> HTH > > >> -- > > >> -Larry- > > >> -- > > >> > > >> "Shannon" <Shan***@discussions.microsoft.com> wrote in message > > >> news:0251BBA4-0137-40B0-86DB-8EC5093EA15B@microsoft.com... > > >> > How do I get the page numbers to restart (1 of __) for each record in a > > >> > report? Right now each record in the report is about 3 pages, which is > > >> fine, > > >> > but when doing several records the first record says 1 of 6 instead of > > >> > 1 > > >> of > > >> > 3. Thanks. > > >> > > >> > > >> > > > > > > Hi Shannon,
I wasn't paying full attention when I read your post and gave you some misinformation. Sorry. You've been getting better info from Bruce. Disregard my earlier post. -- Show quote-Larry- -- "BruceM" <Bru***@discussions.microsoft.com> wrote in message record in anews:1AD7A3E7-D5EC-445D-B02D-8986E96E18DA@microsoft.com... > Shannon, I have used this code and it works quite well. Be sure to read the > instructions very carefully. You may have missed the instruction about > placing Me!ctlGrpPages in the footer. Add an unbound text box to the footer > and name it ctlGrpPages. To insert the code, in Report design view click > View > Code, go to the top of the code window, delete "Option Compare > Database" (since it is already in the code provided), and paste the code. > The code numbers pages within a group, so unless you group your records the > code has nothing on which to work. Click View > Sorting and Grouping, and > group by the primary key field. See Help as needed for more information on > Grouping. Check the code carefully to be sure you have replaced all of the > sample control names with your actual control names. Four lines from the > bottom of the code is a line that starts Me!ctlGrpPages =. Change what is in > quotes on that line to alter what will appear. As the code stands it will > read "Group Page 1 of 2". If you remove the word Group you will see "Page 1 > of 2". > > "Shannon" wrote: > > > Mark, I tried this, but nothing happened. I am a beginner user so I'm a > > little lost with "code", but I copied and pasted and changed the > > Me!Salesperson to the ID for the table. I haven't grouped anything, I just > > want page numbers for each record, instead of all records. I appreciate the > > help, but I'm afraid this is way over my head. Shannon > > > > "Mark" wrote: > > > > > Try this link, it seems a lot simpler than what I had used in the past... > > > http://www.mvps.org/access/reports/rpt0013.htm > > > > > > > > > "Shannon" <Shan***@discussions.microsoft.com> wrote in message > > > news:B7A6AAC6-D020-44B6-A4CA-34082C89FB34@microsoft.com... > > > > Larry, I tried that, but it's still saying 3 of 5, 4 of 5, 5 of 5 after > > > > the > > > > record. Maybe I'm missing something. Shannon > > > > > > > > "Larry Daugherty" wrote: > > > > > > > >> Hi Shannon, > > > >> > > > >> Put your Page textbox in the footer for the record rather than the page > > > >> footer. > > > >> > > > >> HTH > > > >> -- > > > >> -Larry- > > > >> -- > > > >> > > > >> "Shannon" <Shan***@discussions.microsoft.com> wrote in message > > > >> news:0251BBA4-0137-40B0-86DB-8EC5093EA15B@microsoft.com... > > > >> > How do I get the page numbers to restart (1 of __) for each Show quote > > > >> > report? Right now each record in the report is about 3 pages, which is > > > >> fine, > > > >> > but when doing several records the first record says 1 of 6 instead of > > > >> > 1 > > > >> of > > > >> > 3. Thanks. > > > >> > > > >> > > > >> > > > > > > > > >  |
|||||||||||||||||||||||
Other interesting topics