How do I paginate a report in Access?

[Guest]

I am trying to create a booklet from an Access Report, and I need to paginate
it, but I would like to do this without the use of a different program. Is
pagination possible with Access?

 

[Ken Snell \(MVP\)]

By pagination, you want to put the page number on each page? If yes, put a
textbox in the page footer section, and use this as the control source:

=[Page]

If you want "page x of y":

="Page " & [Page] & " of " & [Pages]

 

[Guest]

No. I am trying to make a folded booklet from a report. For example my report
is statement size (8.5" x 5.5" landscape) and 50 sheets (two page #'s per
sheet). I need my booklet to be 5.5" tall by 4.25" wide (statement folded in
half). So my problem is that if I was to print all 50 sheets and fold them in
half, page 2 is where page 100 should be.

By pagination, you want to put the page number on each page? If yes, put a
textbox in the page footer section, and use this as the control source:

=[Page]

If you want "page x of y":

="Page " & [Page] & " of " & [Pages]

--

Ken Snell
<MS ACCESS MVP>

I am trying to create a booklet from an Access Report, and I need to
paginate
it, but I would like to do this without the use of a different program. Is
pagination possible with Access?

 

[Ken Snell \(MVP\)]

Hmm... I don't know of any way to do what you seek in ACCESS directly. You
might experiment with exporting the report to an .rtf format, and trying to
set it up in Word that way.

--

Ken Snell
<MS ACCESS MVP>

No. I am trying to make a folded booklet from a report. For example my
report
is statement size (8.5" x 5.5" landscape) and 50 sheets (two page #'s per
sheet). I need my booklet to be 5.5" tall by 4.25" wide (statement folded
in
half). So my problem is that if I was to print all 50 sheets and fold them
in
half, page 2 is where page 100 should be.

By pagination, you want to put the page number on each page? If yes, put
a
textbox in the page footer section, and use this as the control source:

=[Page]

If you want "page x of y":

="Page " & [Page] & " of " & [Pages]

--

Ken Snell
<MS ACCESS MVP>

I am trying to create a booklet from an Access Report, and I need to
paginate
it, but I would like to do this without the use of a different program.
Is
pagination possible with Access?

 

[Guest]

Thanks. I wondered that. I guess my next question is how would I paginate it
in Word?

Hmm... I don't know of any way to do what you seek in ACCESS directly. You
might experiment with exporting the report to an .rtf format, and trying to
set it up in Word that way.

--

Ken Snell
<MS ACCESS MVP>

No. I am trying to make a folded booklet from a report. For example my
report
is statement size (8.5" x 5.5" landscape) and 50 sheets (two page #'s per
sheet). I need my booklet to be 5.5" tall by 4.25" wide (statement folded
in
half). So my problem is that if I was to print all 50 sheets and fold them
in
half, page 2 is where page 100 should be.

By pagination, you want to put the page number on each page? If yes, put
a
textbox in the page footer section, and use this as the control source:

=[Page]

If you want "page x of y":

="Page " & [Page] & " of " & [Pages]

--

Ken Snell
<MS ACCESS MVP>

I am trying to create a booklet from an Access Report, and I need to
paginate
it, but I would like to do this without the use of a different program.
Is
pagination possible with Access?

 

[Ken Snell \(MVP\)]

Checked with some VMP buddies of mine. They strongly recommend ClickBook:
http://www.bluesquirrel.com/products/clickbook/

They say it costs $50, but is more than worth the price. It apparently will
do what you seek, and will do a lot more too.

--

Ken Snell
<MS ACCESS MVP>

Thanks. I wondered that. I guess my next question is how would I paginate
it
in Word?

Hmm... I don't know of any way to do what you seek in ACCESS directly.
You
might experiment with exporting the report to an .rtf format, and trying
to
set it up in Word that way.

--

Ken Snell
<MS ACCESS MVP>

No. I am trying to make a folded booklet from a report. For example my
report
is statement size (8.5" x 5.5" landscape) and 50 sheets (two page #'s
per
sheet). I need my booklet to be 5.5" tall by 4.25" wide (statement
folded
in
half). So my problem is that if I was to print all 50 sheets and fold
them
in
half, page 2 is where page 100 should be.

:

By pagination, you want to put the page number on each page? If yes,
put
a
textbox in the page footer section, and use this as the control
source:

=[Page]

If you want "page x of y":

="Page " & [Page] & " of " & [Pages]

--

Ken Snell
<MS ACCESS MVP>

I am trying to create a booklet from an Access Report, and I need to
paginate
it, but I would like to do this without the use of a different
program.
Is
pagination possible with Access?

 

[Chuck]

No. I am trying to make a folded booklet from a report. For example my report
is statement size (8.5" x 5.5" landscape) and 50 sheets (two page #'s per
sheet). I need my booklet to be 5.5" tall by 4.25" wide (statement folded in
half). So my problem is that if I was to print all 50 sheets and fold them in
half, page 2 is where page 100 should be.

By pagination, you want to put the page number on each page? If yes, put a
textbox in the page footer section, and use this as the control source:

=[Page]

If you want "page x of y":

="Page " & [Page] & " of " & [Pages]

--

Ken Snell
<MS ACCESS MVP>

I am trying to create a booklet from an Access Report, and I need to
paginate
it, but I would like to do this without the use of a different program. Is
pagination possible with Access?

Assign a sequential number to each record. Example [rcd]

Then assuming you alrerady have your report printing correctly, that is when
the pages are folded and put together they are in order just like a book.
(This can be done in Access. A complex sort field [Sort Order] is created in
the query that the report is based on. The sort order is based on the number
of records per page and the total number of records to be printed)

Add a text box to the top of the Detail section, Top of text box = 0, Height =
0.0007, Can grow = Y, Can shrink = Y. Make the top of the control for the
first record = 0.0014.

Assuning 3 records per page:
In the text box enter: =iif([rcd]=1, "Page 1","") & iif([red]=4, "Page 2","")
& iif([rcd]=7, "Page 3","") and so on. You can nest 8 iif commands in one
statement. Then put in an '&' and do 8 more until you have all you need.

 

[Stephen Lebans]

Ken I'm not sure is Arvin will appreciate the VMP(Very Mature Person) tag.
Plus now you will have to come up with one for Larry...perhaps
EVMP(Extremely Very Mature Person).<grin>
;-)


HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[Ken Snell \(MVP\)]

Hoo boy.... when I do dyslexic typing, I do it well!

 

[John Spencer]

Not your fault, obviously MS failed to autocorrect your error.
OR perhaps you are transitioning into VMP yourself.

 

[Guest]

Thanks Ken, Clickbook does the trick!

Checked with some VMP buddies of mine. They strongly recommend ClickBook:
http://www.bluesquirrel.com/products/clickbook/

They say it costs $50, but is more than worth the price. It apparently will
do what you seek, and will do a lot more too.

--

Ken Snell
<MS ACCESS MVP>

Thanks. I wondered that. I guess my next question is how would I paginate
it
in Word?

Hmm... I don't know of any way to do what you seek in ACCESS directly.
You
might experiment with exporting the report to an .rtf format, and trying
to
set it up in Word that way.

--

Ken Snell
<MS ACCESS MVP>

No. I am trying to make a folded booklet from a report. For example my
report
is statement size (8.5" x 5.5" landscape) and 50 sheets (two page #'s
per
sheet). I need my booklet to be 5.5" tall by 4.25" wide (statement
folded
in
half). So my problem is that if I was to print all 50 sheets and fold
them
in
half, page 2 is where page 100 should be.

:

By pagination, you want to put the page number on each page? If yes,
put
a
textbox in the page footer section, and use this as the control
source:

=[Page]

If you want "page x of y":

="Page " & [Page] & " of " & [Pages]

--

Ken Snell
<MS ACCESS MVP>

I am trying to create a booklet from an Access Report, and I need to
paginate
it, but I would like to do this without the use of a different
program.
Is
pagination possible with Access?

 

[Ken Snell \(MVP\)]

Yes to both! < g >