Printing a second copy of page 2

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I can't imagine how this could be done, but...is there any way to print the
second page of a report twice. That is to say, in a two-page report i would
like to print the first page once and the second (last) page twice. Note that
the second page is initiated with a page break line.

I will try anything, my goal is to print from a button on an Access form so
i'm thinking VB programming may be my only hope. Any options or am I just
crazy?
 
From your description, I think you have one enormously high detail section,
that is split over page 1 and 2? If so you could use the sections of the
report to achieve what you want.

1. Open the report in design view.

2. Open the Sorting'n'Grouping dialog (View menu).

3. In the upper pane of this dialog, select the primary key field.
In the lower pane, set Group Header and Group Footer to Yes.
Access adds 2 new sectons to the report.

4. Move all the stuff for page 1 into the Group Header section, leaving all
the stuff for page 2 in the detail section.

5. Copy all the controls in the Detail section at once (by dragging the
mouse over the lot). Copy (Ctrl+C). Select the group footer section (gray
bar). Paste (Ctrl+V).

The group footer now contains all the same stuff as the detail section.
Since the grouping is performed on the primary key, you end up with the
group header and footer printed for every record. In this way, you end up
with the stuff in the group header, then the stuff from the detail section,
then the stuff from the group footer. And since the detail section and the
group footer print the same thing, page 2 effectively prints twice.

Naturally, set the ForceNewPage property of the 3 sections so you get your
page break.
 
Allen,
that particular method works nicely, but unfortunately it does not fully
solve my problem. I use the report footer for calculating totals on the
second page. Thus when I print using that method, the first copy of the
second page contains only the detail section (no totals), but the second copy
does print a full page. Is there any way to emulate another report footer
section?

The reports detail section (which does effectively print twice) is populated
by a subform if that helps.
 
Create a second grouping by your key field (same as your
other grouping except no group header). Drag this grouping
above the one you created for Allan.

This should give you an additional group footer below the
the one filled with "detail". Your calculations / totals
can go here.

HTH

Terry
 
Back
Top