print in PDF

[legolas75]

Hello,
I've been trying to print an access report to pdf.
I've looked at thread707-1119207 and it runs - the printer icon pops up and shows that a document is spooling, the adobe icon shows that pages are printing to pdf. However when it is all done and there is nothing left in the print que there is no document either. Maybe I'm missing something. I checked both C:\ and my documents to look for the pdf file that was supposed to be created - I did a search too but found nothing. If anyone has gotten this to work for them perhaps you can help me. Thanks. Mike

 

[legolas75]

The one other thing I've noticed is that the VBA code is still running. I simply created a blank form and put a command button on it from which I called the function RunReportAsPDF.

Private Sub cmd_Canned_Rpts_Click()
Call RunReportAsPDF("1 rpt_Summary", "rpt1")
End Sub

For some reason the code keeps running. Maybe this is the problem why the pdf file never shows up. ?

 

[bradles]

legolas75, try

http://www.lebans.com/reporttopdf.htm

at Stephen Lebans great site. I've found this to work much more consistently than any any method so far.

 

[legolas75]

I'll check it out. Thanks.