Print starting on 2nd Page

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

Guest

I have cmd button on a form to print a report. If am mailing the report, I
do not want to print the first page of the report. The user selects whether
the report is faxed or mailed.

I can use the PrintOut action but need to make the report the active object.
This causes problems. I do not want the report to preview first (i.e.
OpenReport). I do not want the Database window to appear (i.e. SelectObject).

Any suggestions. Thank you.


Dim strDocName As String

strDocName = "Letter"

Select Case cmbSendBack
Case "MAIL"
DoCmd.SelectObject , stDocName, True 'Database Window appears
DoCmd.OpenReport strDocName, acViewPreview 'Report Previews
DoCmd.PrintOut acPrintAll, 2
Else
End Select
 
I'm guessing that the first page is a fax cover sheet so you could just
create two reports, one the cover sheet and the other the letter (page 2).
Print only the letter if Case is "MAIL" or print both if it isn't or you
could simply print both, no matter, and discard the fax cover if it is mail.
Either way, they don't see the preview or the db window.
 
Back
Top