Originally Posted by
JimmySupport
I have looked at the sample...does that mean I have to have a list of reports as he does in order to call it? I am trying to use it to make pdfs of invoices and was trying to place a cmd button to do it...am I all wet?
All the example uses the Listbox to get the name of the report. You can hard code the report name if that is what you need.
Here is the example with the comments removed and the function changed to be hard coded with a specific report name.
Code:
Private Sub cmdReportToPDF_Click()
Dim blRet As Boolean
blRet = ConvertReportToPDF("Report_Name_Here", vbNullString, "c:\Invoice.pdf", False, True, 0, "", "", 0, 0)
End Sub
In the above example you will need to substitute Report_Name_Here with the actual name of your access report.You will also need to change c:\Invoice.pdf to the desire full path name you want to use.
That us it. Just to lines of VBA code.
PS: What type of support do you do?