Ms access 2003 reports

Question

I am using following code to generate a print dialogue by using a command button for the report. By using print dialog just by selecting PDF in the printername...changing it to into PDF format.

But I want the report to be converted into PDF directly without prompting print dialog.

Private Sub Wrapper_History_Click()
On Error GoTo Err_Wrapper_History_Click

    Dim stDocName As String

    DoCmd.OpenReport "rptEventLog", acPreview, , _
       "[TrackingNumber] = Forms!frmReviewReleaseWrapper!RevRelTrackingNumber"
    DoCmd.RunCommand acCmdPrint

Exit_Wrapper_History_Click:
    Exit Sub

Err_Wrapper_History_Click:
    MsgBox Err.Description
    Resume Exit_Wrapper_History_Click

End Sub

Answer 1

For Access 2003 and orlder use A2000ReportToPDF is an Access 2000 database containing a function to convert Reports and Snapshot files to PDF documents. No PDF Printer driver is required. Free.

My understanding in Access 2007 and 2010 is that the built in PDF function works well. Access 2010 no longer has the Snapshot printing capability so you can't use the Lebans solution in A2010.