2nd Copy of report to Say COPY

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

Guest

I have a button to print a report. I need two copies, one saying "Original"
and the second saying "COPY" . Do I have to create two separate reports or is
there a way thru code to 'enable' a lable "copy" after the first report is
printed.
 
You can create a table tblCopies with two fields
[CopyNum] [CopyTitle]
1 Original
2 COPY

Add this table to your report's record source. Add both fields to the grid.
Set your primary sorting and grouping level to CopyNum and display the group
header and footer. These can become your "report Header and Footer
sections". Add the CopyTitle to the CopyNum header or footer.
 
MN:

We have a file on our web in the free files section called "Other Reports"
that shows how you can print multiple copies of a report at once with the
Original and Copy designations.
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

Duane Hookom said:
You can create a table tblCopies with two fields
[CopyNum] [CopyTitle]
1 Original
2 COPY

Add this table to your report's record source. Add both fields to the
grid. Set your primary sorting and grouping level to CopyNum and display
the group header and footer. These can become your "report Header and
Footer sections". Add the CopyTitle to the CopyNum header or footer.

--
Duane Hookom
MS Access MVP


mn said:
I have a button to print a report. I need two copies, one saying
"Original"
and the second saying "COPY" . Do I have to create two separate reports
or is
there a way thru code to 'enable' a lable "copy" after the first report
is
printed.
Click to expand...
Click to expand...
 
Back
Top