Double sided printing

[Gordon Jones]

I have a user who has a printer that will print on both sides of the page.
My program generates statements of donations by church members that may be
any number of pages. Is there a way to programmaticaly add a blank sheet if
the generated report has an odd number of pages?

Thanks in advance for suggestions.

 

[Chuck]

I have a user who has a printer that will print on both sides of the page.
My program generates statements of donations by church members that may be
any number of pages. Is there a way to programmaticaly add a blank sheet if
the generated report has an odd number of pages?

Thanks in advance for suggestions.

Make a group header for each member. Set name of group header to:
GroupHeader0. Sort by a unique member nomenclature. Place a PageBreak control
in the header. Name the page break EvenPageBreak. Set properties to: Left =
0, Top = 0.0007.
Push the top of the detail section up against the bottom of the page break
control.

Place this code in the On Format property of the group header. I apologize to
the author of the original code. I didn't write the code and I don't remember
who did. I going to start adding a comment line in all the code blocks I
receive with the original authors name.

Private Sub GroupHeader0_Format(Cancel As Integer, FormatCount As Integer)
Me.EvenPageBreak.Visible = ((Me.Page Mod 2) = 0)
End Sub

Chuck

 

[John... Visio MVP]

I have a user who has a printer that will print on both sides of the page.
My program generates statements of donations by church members that may be
any number of pages. Is there a way to programmaticaly add a blank sheet
if
the generated report has an odd number of pages?

Thanks in advance for suggestions.

The printer should take care of it automatically. When finished the printer
will eject the last piece of paper whether there is printing on the backside
or not.

John... Visio MVP

 

[Gordon Jones]

Thanks for the lead, Chuck. I learned a lot over the past 4 or 5 days. I
had been using my heading for various families as "Page Heading", so I moved
that code to the GroupHeader0, and that caused all the detail to print
without any heading. I tried all sorts of variations on this, and eventually
got the dumb thing to do what I wanted by simply treating each statement
(which could be from 1 to 4 or so pages) as a report, sending each off to the
printer by itself. This required a relatively simple routine to walk through
the queries for the various groupings and sending each to a statement print
report for a single family.

For the life of me, I can't see how what I wanted to do is so unusual or
difficult, but that's life in the big city.

Thanks again,