print report to pdf

[Question Boy]

I am looking for a method to print a report to pdf using acrobat 6.0 all in
vba without user interaction. Basically switch to the pdf printer, print,
switch back to the default printer.

I have looked long and hard on google and found nothing that is seemless
(lots of tid bits but never a complete solution or enough that I can piece
together). It worked fine in 5.0 but now in 6 I can't seem to pass the file
name to be used.

I tried Albert's switch printer code, but the user gets prompted for the
filename. I could live with that if I could trap what they name it and where
it gets saved, but haven't figured out how.

Thank you for the help,

QB

 

[Question Boy]

Also worth noting that I'm working with a 2003 database

 

[Albert D. Kallal]

I would suggest you consider using Stephen solution here:

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

There are many advantages to the above reproach and solution:

First and foremost you don't have to install any version of acrobat at all
on your computer.

Furthermore as you well realized the each time a adobe issues an update to
their software, it is typical that your existing code will break and cease
to function. That means you gonna spend a lot of money that you could give
to the poor and the local soup kitchens on maintaining and updating your
software for really no discernible benefits.

The other advantage of Stephen solution is it is completely free, and
furthermore does not require you to switch your printers at all.

In fact you don't even have to install a printer driver. Since you don't
have to install a printer, then this makes distribution of your access
application a far more trouble free process.