Print order...

[Guest]

With the help of Doug in my following post..... one can print my report last
page first... etc....

I would like to twist the post again as follows, print only the last page
first and the rest of the pages remain in the same order ie (For each of my
records that print)

page 3 print as 1st page
page 1 print as the second page
page 2 print as the third page

http://www.microsoft.com/office/com...96a4&mid=6928572c-fed2-41f8-90c7-20c2ef7796a4

 

[Douglas J Steele]

Never satisfied, eh? <g>

Dim intPage As Integer
Dim strReport As String

strReport = "MyReport"

DoCmd.OpenReport strReport, acViewPreview
intPage = Application.Reports(strReport).Pages
DoCmd.PrintOut acPages, intPage, intPage
DoCmd.PrintOut acPages, 1, (intPage - 1)
DoCmd.Close acReport, strReport


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

With the help of Doug in my following post..... one can print my report last
page first... etc....

I would like to twist the post again as follows, print only the last page
first and the rest of the pages remain in the same order ie (For each of my
records that print)

page 3 print as 1st page
page 1 print as the second page
page 2 print as the third page

http://www.microsoft.com/office/com...-us&dg=microsoft.public.access&p=1&tid=692857
2c-fed2-41f8-90c7-20c2ef7796a4&mid=6928572c-fed2-41f8-90c7-20c2ef7796a4

 

[Guest]

Thanks alot Doug, I appreaciate all the help you have provided me all this
time......