Generating Access report to pdf to print 2-sided 1

[Stonewall42]

I have a large report that runs in Access that is several hundred pages long. It consists of several smaller individual client reports that are then matched up with an externally generated document and mailed out. These client reports already paginate properly, starting over with Page 1 when needed. Some of the smaller reports can be one page to 20 pages each or more. What I would like to do is have these smaller individual client reports print 2-sided. Obviously, if a specific client's report is only one page, the front of the page would have information, and the back would be blank, then the next client's report prints. But for the larger client reports, I could save a lot of paper and some mailing costs by having, say a 20 page item print on 10 pages.

This large report is produced in Access and the output generated through Adobe Acrobat to create a pdf. This allows me to keep an electronic back up. Not sure if the solution I need is something that can be done in Access or, is it an Adobe pdf issue, or perhaps both. I do have printers available that can print 2-sided, or double-sided.

Any guidance and insight is appreciated. I am using Access 2003

 

[PWise]

if you have a printer that can print double-sided you shoul not have any problem printing just when you print select double-sided in the propties. What you do have to watch for is if a report for a client is a odd amount of pages that the report for the second client should not start to print on the back of the first report

 

[MichaelRed]

Skipping the empty pages is not all that difficult. Assuming the report is grouped by the client, have a text box (in the group footer) whose .visible property may be set based on the 'oddness' of the page number. Have the textbox text be "This page intentionally blank".

The "page" must print (to have the following page be printed on the "FRONT" of hte followiing 'sheet). The intentionally blank statement prevents the report consumer(s) from askiing if there was some additional material whivh was omitted.




MichaelRed

 

[Stonewall42]

Hadn't thought about trying to skip the odd page by having something like "Page Intentionally Left Blank" printed on it. Basiclly, it would occur whenever the next page, after page 1 of the previous client's report was page 1. You seem to be saying there is a way to do this, although I might be saying badly or unclearly. I would need this because if a client's report is 1 page or 21 pages, the back side of the ending page, if it is odd, would need that message. Is that right?

 

[MichaelRed]

If the 'front' page number is odd (e.g. 1, or 21), then the 'back' (e.g. corresponding 2 or 22) number is even.

the logic is in the group footer (See GroupFooter2 below), as it occurs once at the end of each group, so in the group footer you can test for the oddness of the page number and use it to set the (control) ctrlPgBrk.visible property.

The (optional) text of your choice may be 'printed' in the following GroupHeader (See GroupHeader0 Below) by setting txtBlankPage.Visible property according to the Form level variable blnBlankPage

Private Sub GroupFooter2_Format(Cancel As Integer, FormatCount As Integer)
    blnBlankPage = (Page Mod 2 <> 0)
    ctrlPgBrk.Visible = blnBlankPage
End Sub
Private Sub GroupHeader0_Format(Cancel As Integer, FormatCount As Integer)
    txtBlankPage.Visible = blnBlankPage
End Sub



MichaelRed