Page 1 of 1

Creating PDF from MS Access

Posted: Wed Nov 14, 2007 5:09 pm
by Roebie
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.

Posted: Fri Feb 29, 2008 11:26 am
by cwany
I'm not sure, but i would add a
[code].WriteSettings[/code]
line before printing