C
Connie
Using Access 2003, I created a 2-page report for someone who wants the report
to print duplexed. And it works fine, except….he is using a special “carbon
copy†paper and needs page 1 to print on the proper side. His printer prints
Page 2 first and then prints Page 1 on the back side. I need to do something
to get Page 1 to print first and print Page 2 on the back side.
I tested this on my HP4700dtn printer, and apparently duplexing works the
same on my printer, too. Microsoft Word has a print option feature called
“Reverse Print Order†(File – Print – Options button) and when I used that in
Word to test, I got the results I needed. I cannot find a similar feature in
Access to reverse the order that the pages print and still be duplexed.
I tried using some PrintOut code I found in this discussion group. The
pages printed in the order I needed but did not duplex. The code I tried was:
Dim strReport As String
Dim intPage As Integer
stDocName = "MyReport"
DoCmd.OpenReport strReport, acViewPreview
For intPage = 1 To Application.Reports(strReport).Pages Step 1
DoCmd.PrintOut acPages, intPage, intPage
Next intPage
DoCmd.Close acReport, strReport
Since this is a 2-paged report, I can do a workaround and, in Report Design
View, move my Page 2 to Page 1 so that Page 1 becomes Page 2. But I would
like to have a solution for if the report were say 4 or 6 pages.
I’d appreciate any help anyone can give me.
to print duplexed. And it works fine, except….he is using a special “carbon
copy†paper and needs page 1 to print on the proper side. His printer prints
Page 2 first and then prints Page 1 on the back side. I need to do something
to get Page 1 to print first and print Page 2 on the back side.
I tested this on my HP4700dtn printer, and apparently duplexing works the
same on my printer, too. Microsoft Word has a print option feature called
“Reverse Print Order†(File – Print – Options button) and when I used that in
Word to test, I got the results I needed. I cannot find a similar feature in
Access to reverse the order that the pages print and still be duplexed.
I tried using some PrintOut code I found in this discussion group. The
pages printed in the order I needed but did not duplex. The code I tried was:
Dim strReport As String
Dim intPage As Integer
stDocName = "MyReport"
DoCmd.OpenReport strReport, acViewPreview
For intPage = 1 To Application.Reports(strReport).Pages Step 1
DoCmd.PrintOut acPages, intPage, intPage
Next intPage
DoCmd.Close acReport, strReport
Since this is a 2-paged report, I can do a workaround and, in Report Design
View, move my Page 2 to Page 1 so that Page 1 becomes Page 2. But I would
like to have a solution for if the report were say 4 or 6 pages.
I’d appreciate any help anyone can give me.