L
Lamar
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
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