Creating PDF from MS Access
Posted: Wed Nov 14, 2007 5:09 pm
Hi,
Your PDF Printer is great. I've been using it for some time without problems...until now.
When I use it from Excel (like in [url]http://bullzip.com/phpBB2/viewtopic.php?t=1815[/url]) everything works fine. Same for MS Word. But printing a report from MS Access fails.
I use a macro with this code:
[code]Public Sub myMacro()
Dim bull As New Bullzip.PDFPrinterSettings
With bull
.SetValue "Output", "D:\myPrintedReport.pdf"
.SetValue "ShowSettings", "never"
.Author "Bart Degryse"
End With
DoCmd.OpenReport "myReport", acViewNormal
End Sub[/code]
Since the report is defined with Bullzip as printer and since acViewNormal means that the report is sent to the defined printer, I would expect to get a pdf file. Well, I don't. I just get a dialog box asking me to confirm the filename for the pdf. The proposed filename seems to be derived from the name of the Access file. The runonce.ini file gets correctly written though.
I've tried all sorts of variations (output path without spaces, short paths, writing the ini file with the filesystemobject, writing it with pure i/o, by setting more or less PDFPrinterSettings properties) but nothing seems to help.
Can anyone tell me what I'm doing wrong?
Many many thanks in advance.
Your PDF Printer is great. I've been using it for some time without problems...until now.
When I use it from Excel (like in [url]http://bullzip.com/phpBB2/viewtopic.php?t=1815[/url]) everything works fine. Same for MS Word. But printing a report from MS Access fails.
I use a macro with this code:
[code]Public Sub myMacro()
Dim bull As New Bullzip.PDFPrinterSettings
With bull
.SetValue "Output", "D:\myPrintedReport.pdf"
.SetValue "ShowSettings", "never"
.Author "Bart Degryse"
End With
DoCmd.OpenReport "myReport", acViewNormal
End Sub[/code]
Since the report is defined with Bullzip as printer and since acViewNormal means that the report is sent to the defined printer, I would expect to get a pdf file. Well, I don't. I just get a dialog box asking me to confirm the filename for the pdf. The proposed filename seems to be derived from the name of the Access file. The runonce.ini file gets correctly written though.
I've tried all sorts of variations (output path without spaces, short paths, writing the ini file with the filesystemobject, writing it with pure i/o, by setting more or less PDFPrinterSettings properties) but nothing seems to help.
Can anyone tell me what I'm doing wrong?
Many many thanks in advance.