page numbers in report restart per record

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Shannon - 25 Feb 2005 21:32 GMT

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.

Reply to this Message

Larry Daugherty - 25 Feb 2005 22:10 GMT

Hi Shannon,

Put your Page textbox in the footer for the record rather than the page
footer.

HTH

Signature

-Larry-
--

> 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.

Reply to this Message

Shannon - 28 Feb 2005 14:25 GMT

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

> Hi Shannon,
>
[quoted text clipped - 8 lines]
> of
> > 3. Thanks.

Reply to this Message

Mark - 28 Feb 2005 16:12 GMT

Try this link, it seems a lot simpler than what I had used in the past...
http://www.mvps.org/access/reports/rpt0013.htm

> Larry, I tried that, but it's still saying 3 of 5, 4 of 5, 5 of 5 after
> the
[quoted text clipped - 13 lines]
>> of
>> > 3. Thanks.

Reply to this Message

Shannon - 28 Feb 2005 21:21 GMT

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

> Try this link, it seems a lot simpler than what I had used in the past...
> http://www.mvps.org/access/reports/rpt0013.htm
[quoted text clipped - 16 lines]
> >> of
> >> > 3. Thanks.

Reply to this Message

BruceM - 01 Mar 2005 13:07 GMT

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".

> 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
[quoted text clipped - 22 lines]
> > >> of
> > >> > 3. Thanks.

Reply to this Message

Larry Daugherty - 02 Mar 2005 02:23 GMT

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.

Signature

-Larry-
--

> 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
[quoted text clipped - 38 lines]
> > > >> of
> > > >> > 3. Thanks.

Reply to this Message