I am printing business cards from an access report using a macro.
On my print form I enter a customer number and click Print and the card constructed using that client's info is displayed WYSIWYG in the report. I then print the report.
I designed the card on the print form design, then copied it to the report design.
Each business card at present is a separate job and uses one sheet of A4 paper. Is there a way I could queue the output of several of the reports and then print several cards on one sheet?
Private Sub cmdPrint_Click()
DoCmd.OpenReport "rptPrintFCC", acPrintPreview, , [Client number] = [Forms]![frmPrintFCC]![Client number]