Report for many pages of the same record

  • Thread starter Thread starter Joe Williams
  • Start date Start date
J

Joe Williams

I have a report that is a half sheet of 8.5 x 11 inch paper. The data source
for this report is always one record.

Now, what I need to be able to do is to send a parameter to the report that
tells the report how many copies of the record to print. For instance, if I
say to print 50 copies, then the report would print 25 pages of the same
record, two records per page.

I have the report all set up, what I need to know is how to tell access to
use 50 copies of the same record when needed.

any ideas? Thanks in advance

Joe
 
I have a report that is a half sheet of 8.5 x 11 inch paper. The data source
for this report is always one record.

Now, what I need to be able to do is to send a parameter to the report that
tells the report how many copies of the record to print. For instance, if I
say to print 50 copies, then the report would print 25 pages of the same
record, two records per page.

I have the report all set up, what I need to know is how to tell access to
use 50 copies of the same record when needed.

any ideas? Thanks in advance

Joe
Click to expand...

Code a command button click event:
Dim intHowMany As Integer
intHowMany = InputBox("How Many Pages?", "Enter number of pages", 1)
DoCmd.SelectObject acReport, "ReportName", True
DoCmd.PrintOut acPrintAll, , , , intHowMany

In VBA Help look up the PrintOut method, as well as SelectObject for
all the arguments.
 
In order to print the same record twice, you'll need 1 set of bound fields
and a second set of unbound fields. In the format event of the detail
section you'll need to manually populate the unbound fields. The user can
specify the number of copies when he chooses to print..
 
Back
Top