Printing reports

  • Thread starter Thread starter FatMax
  • Start date Start date
F

FatMax

I'd like to be able to print two reports simultaneously - rptTable1 and
rptTable2. Can do this easilly enough using the macro builder on a form -
two OpenReport commands. However I usually want more than one copy of each
report (say 20 copies). Is it possible to specify on the form the number of
copies I want to print?

Hope this makes sense
FatMax
 
tina said:
to the macro, but you can do it in VBA. i used an unbound
textbox control on a form, into which i typed the number
of copies i wanted to print. then i used a command button
on the same form to make the print request. here's the
code i ran from the command button:

Private Sub Command0_Click()

DoCmd.OpenReport "Report1", acViewPreview
DoCmd.SelectObject acReport, "Report1"
DoCmd.PrintOut , , , , Forms!Form1!Text1
DoCmd.Close acReport, "Report1"

DoCmd.OpenReport "Report2", acViewPreview
DoCmd.SelectObject acReport, "Report2"
DoCmd.PrintOut , , , , Forms!Form1!Text1
DoCmd.Close acReport, "Report2"

End Sub
Click to expand...
Just what I need. Thanx v. much for your time.
 
Back
Top