Group:  Microsoft Access ยป microsoft.public.access.reports
Thread: Page Numbers

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

Page Numbers
Nikki 30.08.2006 20:17:02
Is there a way to print the page number of the report for that record at the
bottom of the page?

eg: If the report has 3 pages but there are 50 records each the first page
of each record would say 1 of 3, second say 2 of 3 and so on.
At the moment I have a 2 page report but when i print them it says 1 of 220
because it is counting all the pages of every record.
Re: Page Numbers
"Jeff Boyce" <nonsense[ at ]nonsense.com> 30.08.2006 20:59:16
Nikki

I don't understand "counting all the pages of every record".

If you want to put "Page x of y" at the bottom of each page in an Access
report:

* open the report in design mode
* make sure you have Page Headers/Footers showing
* add a control to the page footer (assuming you want the page number at
the bottom)
* use the following expression - pay attention to the quotes and spaces:
="Page " & [Page] & " of " & [Pages]

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Nikki" <Nikki[ at ]discussions.microsoft.com> wrote in message
news:5DBC13B8-BDA1-4894-AAF5-3D8E59F99877[ at ]microsoft.com...
[Quoted Text]
> Is there a way to print the page number of the report for that record at
> the
> bottom of the page?
>
> eg: If the report has 3 pages but there are 50 records each the first page
> of each record would say 1 of 3, second say 2 of 3 and so on.
> At the moment I have a 2 page report but when i print them it says 1 of
> 220
> because it is counting all the pages of every record.


Re: Page Numbers
"Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> 30.08.2006 21:05:50
Check http://www.mvps.org/access/reports/rpt0013.htm at "The Access Web"

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Nikki" <Nikki[ at ]discussions.microsoft.com> wrote in message
news:5DBC13B8-BDA1-4894-AAF5-3D8E59F99877[ at ]microsoft.com...
[Quoted Text]
> Is there a way to print the page number of the report for that record at
> the
> bottom of the page?
>
> eg: If the report has 3 pages but there are 50 records each the first page
> of each record would say 1 of 3, second say 2 of 3 and so on.
> At the moment I have a 2 page report but when i print them it says 1 of
> 220
> because it is counting all the pages of every record.


Re: Page Numbers
Nikki 30.08.2006 21:20:02

Can you please clarify what it means when it says "change Me!Salesperson to
the control name of the group you wish to track pages for"

"Douglas J. Steele" wrote:

[Quoted Text]
> Check http://www.mvps.org/access/reports/rpt0013.htm at "The Access Web"
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "Nikki" <Nikki[ at ]discussions.microsoft.com> wrote in message
> news:5DBC13B8-BDA1-4894-AAF5-3D8E59F99877[ at ]microsoft.com...
> > Is there a way to print the page number of the report for that record at
> > the
> > bottom of the page?
> >
> > eg: If the report has 3 pages but there are 50 records each the first page
> > of each record would say 1 of 3, second say 2 of 3 and so on.
> > At the moment I have a 2 page report but when i print them it says 1 of
> > 220
> > because it is counting all the pages of every record.
>
>
>
Re: Page Numbers
"Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> 30.08.2006 23:53:38
Presumably you've got a text box on your report that holds the field that
triggers starting a new page. That's the control you'd use instead of
Me!Salesperson.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Nikki" <Nikki[ at ]discussions.microsoft.com> wrote in message
news:D6D833F8-BF4D-445E-BAAC-BE7452783452[ at ]microsoft.com...
[Quoted Text]
>
> Can you please clarify what it means when it says "change Me!Salesperson
> to
> the control name of the group you wish to track pages for"
>
> "Douglas J. Steele" wrote:
>
>> Check http://www.mvps.org/access/reports/rpt0013.htm at "The Access Web"
>>
>> --
>> Doug Steele, Microsoft Access MVP
>> http://I.Am/DougSteele
>> (no private e-mails, please)
>>
>>
>> "Nikki" <Nikki[ at ]discussions.microsoft.com> wrote in message
>> news:5DBC13B8-BDA1-4894-AAF5-3D8E59F99877[ at ]microsoft.com...
>> > Is there a way to print the page number of the report for that record
>> > at
>> > the
>> > bottom of the page?
>> >
>> > eg: If the report has 3 pages but there are 50 records each the first
>> > page
>> > of each record would say 1 of 3, second say 2 of 3 and so on.
>> > At the moment I have a 2 page report but when i print them it says 1 of
>> > 220
>> > because it is counting all the pages of every record.
>>
>>
>>


Re: Page Numbers
Nikki 31.08.2006 00:02:02
Oh ok. No I don't have one. I have a page break that triggers the new page.
Will that work?

"Douglas J. Steele" wrote:

[Quoted Text]
> Presumably you've got a text box on your report that holds the field that
> triggers starting a new page. That's the control you'd use instead of
> Me!Salesperson.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "Nikki" <Nikki[ at ]discussions.microsoft.com> wrote in message
> news:D6D833F8-BF4D-445E-BAAC-BE7452783452[ at ]microsoft.com...
> >
> > Can you please clarify what it means when it says "change Me!Salesperson
> > to
> > the control name of the group you wish to track pages for"
> >
> > "Douglas J. Steele" wrote:
> >
> >> Check http://www.mvps.org/access/reports/rpt0013.htm at "The Access Web"
> >>
> >> --
> >> Doug Steele, Microsoft Access MVP
> >> http://I.Am/DougSteele
> >> (no private e-mails, please)
> >>
> >>
> >> "Nikki" <Nikki[ at ]discussions.microsoft.com> wrote in message
> >> news:5DBC13B8-BDA1-4894-AAF5-3D8E59F99877[ at ]microsoft.com...
> >> > Is there a way to print the page number of the report for that record
> >> > at
> >> > the
> >> > bottom of the page?
> >> >
> >> > eg: If the report has 3 pages but there are 50 records each the first
> >> > page
> >> > of each record would say 1 of 3, second say 2 of 3 and so on.
> >> > At the moment I have a 2 page report but when i print them it says 1 of
> >> > 220
> >> > because it is counting all the pages of every record.
> >>
> >>
> >>
>
>
>
Re: Page Numbers
"Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> 01.09.2006 06:49:10
But why do you skip to a new page? Surely it's not arbitrary, or you
wouldn't care whether your report says 1 of 3, 2 of 3, 3 of 3, 1 of 2, 2 of
2, vs 1 of 5, 2 of 5, 3 of 5, 4 of 5, 5 of 5

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Nikki" <Nikki[ at ]discussions.microsoft.com> wrote in message
news:FDEF7177-19D0-4EB3-9A53-3A7A98EF6987[ at ]microsoft.com...
[Quoted Text]
> Oh ok. No I don't have one. I have a page break that triggers the new
> page.
> Will that work?
>
> "Douglas J. Steele" wrote:
>
>> Presumably you've got a text box on your report that holds the field that
>> triggers starting a new page. That's the control you'd use instead of
>> Me!Salesperson.
>>
>> --
>> Doug Steele, Microsoft Access MVP
>> http://I.Am/DougSteele
>> (no private e-mails, please)
>>
>>
>> "Nikki" <Nikki[ at ]discussions.microsoft.com> wrote in message
>> news:D6D833F8-BF4D-445E-BAAC-BE7452783452[ at ]microsoft.com...
>> >
>> > Can you please clarify what it means when it says "change
>> > Me!Salesperson
>> > to
>> > the control name of the group you wish to track pages for"
>> >
>> > "Douglas J. Steele" wrote:
>> >
>> >> Check http://www.mvps.org/access/reports/rpt0013.htm at "The Access
>> >> Web"
>> >>
>> >> --
>> >> Doug Steele, Microsoft Access MVP
>> >> http://I.Am/DougSteele
>> >> (no private e-mails, please)
>> >>
>> >>
>> >> "Nikki" <Nikki[ at ]discussions.microsoft.com> wrote in message
>> >> news:5DBC13B8-BDA1-4894-AAF5-3D8E59F99877[ at ]microsoft.com...
>> >> > Is there a way to print the page number of the report for that
>> >> > record
>> >> > at
>> >> > the
>> >> > bottom of the page?
>> >> >
>> >> > eg: If the report has 3 pages but there are 50 records each the
>> >> > first
>> >> > page
>> >> > of each record would say 1 of 3, second say 2 of 3 and so on.
>> >> > At the moment I have a 2 page report but when i print them it says 1
>> >> > of
>> >> > 220
>> >> > because it is counting all the pages of every record.
>> >>
>> >>
>> >>
>>
>>
>>


Re: Page Numbers
Nikki 03.09.2006 19:56:01
Because the report itself has 2 pages. When I print of one record at a time
it does say 1 of 2, 2 of 2. BUT when I print all of the records (256 of
them) at the same time then the first record says 1 or 516, 2 of 512, the
second record says 3 of 512, 4 of 512 and so on.

"Douglas J. Steele" wrote:

[Quoted Text]
> But why do you skip to a new page? Surely it's not arbitrary, or you
> wouldn't care whether your report says 1 of 3, 2 of 3, 3 of 3, 1 of 2, 2 of
> 2, vs 1 of 5, 2 of 5, 3 of 5, 4 of 5, 5 of 5
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "Nikki" <Nikki[ at ]discussions.microsoft.com> wrote in message
> news:FDEF7177-19D0-4EB3-9A53-3A7A98EF6987[ at ]microsoft.com...
> > Oh ok. No I don't have one. I have a page break that triggers the new
> > page.
> > Will that work?
> >
> > "Douglas J. Steele" wrote:
> >
> >> Presumably you've got a text box on your report that holds the field that
> >> triggers starting a new page. That's the control you'd use instead of
> >> Me!Salesperson.
> >>
> >> --
> >> Doug Steele, Microsoft Access MVP
> >> http://I.Am/DougSteele
> >> (no private e-mails, please)
> >>
> >>
> >> "Nikki" <Nikki[ at ]discussions.microsoft.com> wrote in message
> >> news:D6D833F8-BF4D-445E-BAAC-BE7452783452[ at ]microsoft.com...
> >> >
> >> > Can you please clarify what it means when it says "change
> >> > Me!Salesperson
> >> > to
> >> > the control name of the group you wish to track pages for"
> >> >
> >> > "Douglas J. Steele" wrote:
> >> >
> >> >> Check http://www.mvps.org/access/reports/rpt0013.htm at "The Access
> >> >> Web"
> >> >>
> >> >> --
> >> >> Doug Steele, Microsoft Access MVP
> >> >> http://I.Am/DougSteele
> >> >> (no private e-mails, please)
> >> >>
> >> >>
> >> >> "Nikki" <Nikki[ at ]discussions.microsoft.com> wrote in message
> >> >> news:5DBC13B8-BDA1-4894-AAF5-3D8E59F99877[ at ]microsoft.com...
> >> >> > Is there a way to print the page number of the report for that
> >> >> > record
> >> >> > at
> >> >> > the
> >> >> > bottom of the page?
> >> >> >
> >> >> > eg: If the report has 3 pages but there are 50 records each the
> >> >> > first
> >> >> > page
> >> >> > of each record would say 1 of 3, second say 2 of 3 and so on.
> >> >> > At the moment I have a 2 page report but when i print them it says 1
> >> >> > of
> >> >> > 220
> >> >> > because it is counting all the pages of every record.
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>
Re: Page Numbers
"Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> 03.09.2006 20:01:22
Sorry, I'm not understanding your explanation.

Are you saying each record is supposed to be a pair of pages? Replace
Me!Salesperson with whatever field represents the Primary Key of your table,
then.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Nikki" <Nikki[ at ]discussions.microsoft.com> wrote in message
news:6CEB2168-3696-41F1-85E6-5BBF58316AC5[ at ]microsoft.com...
[Quoted Text]
> Because the report itself has 2 pages. When I print of one record at a
> time
> it does say 1 of 2, 2 of 2. BUT when I print all of the records (256 of
> them) at the same time then the first record says 1 or 516, 2 of 512, the
> second record says 3 of 512, 4 of 512 and so on.
>
> "Douglas J. Steele" wrote:
>
>> But why do you skip to a new page? Surely it's not arbitrary, or you
>> wouldn't care whether your report says 1 of 3, 2 of 3, 3 of 3, 1 of 2, 2
>> of
>> 2, vs 1 of 5, 2 of 5, 3 of 5, 4 of 5, 5 of 5
>>
>> --
>> Doug Steele, Microsoft Access MVP
>> http://I.Am/DougSteele
>> (no private e-mails, please)
>>
>>
>> "Nikki" <Nikki[ at ]discussions.microsoft.com> wrote in message
>> news:FDEF7177-19D0-4EB3-9A53-3A7A98EF6987[ at ]microsoft.com...
>> > Oh ok. No I don't have one. I have a page break that triggers the new
>> > page.
>> > Will that work?
>> >
>> > "Douglas J. Steele" wrote:
>> >
>> >> Presumably you've got a text box on your report that holds the field
>> >> that
>> >> triggers starting a new page. That's the control you'd use instead of
>> >> Me!Salesperson.
>> >>
>> >> --
>> >> Doug Steele, Microsoft Access MVP
>> >> http://I.Am/DougSteele
>> >> (no private e-mails, please)
>> >>
>> >>
>> >> "Nikki" <Nikki[ at ]discussions.microsoft.com> wrote in message
>> >> news:D6D833F8-BF4D-445E-BAAC-BE7452783452[ at ]microsoft.com...
>> >> >
>> >> > Can you please clarify what it means when it says "change
>> >> > Me!Salesperson
>> >> > to
>> >> > the control name of the group you wish to track pages for"
>> >> >
>> >> > "Douglas J. Steele" wrote:
>> >> >
>> >> >> Check http://www.mvps.org/access/reports/rpt0013.htm at "The Access
>> >> >> Web"
>> >> >>
>> >> >> --
>> >> >> Doug Steele, Microsoft Access MVP
>> >> >> http://I.Am/DougSteele
>> >> >> (no private e-mails, please)
>> >> >>
>> >> >>
>> >> >> "Nikki" <Nikki[ at ]discussions.microsoft.com> wrote in message
>> >> >> news:5DBC13B8-BDA1-4894-AAF5-3D8E59F99877[ at ]microsoft.com...
>> >> >> > Is there a way to print the page number of the report for that
>> >> >> > record
>> >> >> > at
>> >> >> > the
>> >> >> > bottom of the page?
>> >> >> >
>> >> >> > eg: If the report has 3 pages but there are 50 records each the
>> >> >> > first
>> >> >> > page
>> >> >> > of each record would say 1 of 3, second say 2 of 3 and so on.
>> >> >> > At the moment I have a 2 page report but when i print them it
>> >> >> > says 1
>> >> >> > of
>> >> >> > 220
>> >> >> > because it is counting all the pages of every record.
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>>


Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net