Get Output Folder for Application PDF printer

[mcambrose]

I am printing out access reports using Adobe PDF printer driver PDF Writer. I
understand that I can't change the output folder programmatically, but can I
read the value of the output folder property. I tried using
application.printer.port. The value given is "My Documents\*.pdf" but this is
not the output folder for the active printer. I also checked
application.printer.devicename to make sure the correct printer was the
default. Thanks.

 

[dch3]

I'm thinking that its somewhere in the registry. I'd contact Adobe for the
specific information. If its in the registry its a very simple thing to read
the value from there.

 

[mcambrose]

I found out that the port is set separately from the output folder. It seems
that I need to make sure that when I create an adobe printer, I need to use
the same folder for port as I want to use for output and then the port
property will reflect the output folder info.

 

[Steve Sanford]

Have you seen the Stephen Lebans "Access Reports to PDF" page? It doesn't
require a PDF Printer driver. It is great..... I use it in some of my mdb's.

ReportToPDF:

http://lebans.com/reporttopdf.htm


HTH

 

[Dymondjack]

That is the best utility download I think I've ever seen. I've been using
VBA and access for about 5 years now and thats the first time I've seen it.
Muchas Gracias to Mr. Lebans, pdfs are my favorite.

Actually, I had it in mind to look into further liscensing from Adobe, and
this might deter that. Thanks for the post

 

[Tony Toews [MVP]]

That is the best utility download I think I've ever seen. I've been using
VBA and access for about 5 years now and thats the first time I've seen it.
Muchas Gracias to Mr. Lebans, pdfs are my favorite.

Actually, I had it in mind to look into further liscensing from Adobe, and
this might deter that.

Incorrect. Unless you need something really interesting Stephen's
utility *WILL* save you huge licensing costs.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/