creating a pdf from access report

[Andy Chan]

Hoping someone out there has some sample vba code of how to generate a pdf
from Access. My versions are adobe pdf writer version 7, and Access xp.

Been to a couple of sites, and the one I really like requires a
subscription.

Would greatly appreciate any help out there (a url link would be great too).
I've been doing google searches all morning, and sorta get close to what I'm
looking for, but not quite. Is there an old newsgroup thread around that has
this info?


Thanks!

 

[Steve Rindsberg]

Hoping someone out there has some sample vba code of how to generate a pdf
from Access. My versions are adobe pdf writer version 7, and Access xp.

I'd doublecheck the software versions.
There is no Adobe PDFWriter version 7.

If you have PDFWriter, it's version 5 or maybe 6 at the latest.

If you have Acrobat 7, you've got a printer driver called Adobe PDF.

The two are quite different.

 

[Ron Weiner]

Andy

How bout this http://www.tek-tips.com/faqs.cfm?fid=1635

or
http://groups-beta.google.com/group...ast_SpamBegone_.net&hl=en&lr=&c2coff=1&rnum=1

or http://www.mvps.org/access/reports/rpt0011.htm

or
http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=35321&lngWId=1


Ron W

 

[Steve Rindsberg]

All but the second one focus on PDFWriter. That's fine if you have an earlier version
of Acrobat installed and have chosen to install PDFWriter (it's not always installed by
default).

But PDFWriter was discontinued after Acrobat 5, so unless the installed copy of Acrobat
is several years old and has never been upgraded, PDFWriter-based solutions are a
non-starter.

Not trying to be negative, just to save people a little research time.

 

[Andy Chan]

Thanks for the awesome info.

I didn't realize that pdfwriter is no more.

Acrobat 7.0 installs the basic functionality I'm looking for. I had a quick
look. I would have thought that it'd install a module of some kind, much
like how it used to install a word or excel vba module that the toolbar
buttons call (I guess that's now pdfwriter worked), but in this version
there is no mda or xla that I can see.

Thanks for the help guys! Much appreciated.

 

[Steve Rindsberg]

I didn't realize that pdfwriter is no more.

Acrobat 7.0 installs the basic functionality I'm looking for. I had a quick
look. I would have thought that it'd install a module of some kind, much
like how it used to install a word or excel vba module that the toolbar
buttons call (I guess that's now pdfwriter worked)

PDFMaker, not PDFWriter. Adobe's highly adept at coming up with confusing
names. ;-)

PDFWriter is a printer driver; PDFMaker is a set of macros (a set for each of
several Office products) that optionally installs at the time you install
Acrobat. If you install Acrobat before installing Office, you'll have to
reinstall Acrobat to get the PDFMaker stuff to install.

Back to the main question, you might want to try a slightly different approach:

Install pretty much any appropriate PS driver and use it to print to file under
program control. That'll give you a Postscript file you can run through
Distiller (another part of Acrobat) to make PDF.

Have a look here for possible code to automate Distiller (this is for older
versions of Distiller and may not work with 7, but it's worth a try):

Control Distiller from VB/VBA
http://www.rdpslides.com/psfaq/FAQ00053.htm

, but in this version

 

[Ron Weiner]

Steve

Does not Acrobat 7 install a printer driver that you would print to when you
wanted to create a PDF file. I stopped buying Acrobat at Version 5, as that
version has everything I need for Acrobat to EVER do. If you buy Acrobat 7
how would you create a PDF file from an application that Adobe did not
directly support?

Ron W

 

[Andy Chan]

Ron!!


Thanks for the url's!! Exactly what I was looking for!!

 

[Steve Rindsberg]

Steve

Does not Acrobat 7 install a printer driver that you would print to when you
wanted to create a PDF file.

Yes. It's called Adobe PDF.

In Acrobat 5, you've got the Acrobat Distiller printer and optionally PDFWriter as well.
PDFWriter's handy for some things, and generally faster for basic printing like invoices
and the like. Distiller's the better choice for heavy duty graphics and some other uses.

I stopped buying Acrobat at Version 5, as that
version has everything I need for Acrobat to EVER do.

That works for me. I mostly use Acrobat 5 too.

If you buy Acrobat 7
how would you create a PDF file from an application that Adobe did not
directly support?

Same as ever, print to The Name-Of-The-Month driver that prints directly to PDF, <g>.

Distiller Assistant in Acrobat 4 became Acrobat Distiller in Acrobat 5 became Adobe PDF in
Acrobat 6 and wonderofwonders didn't change names in Acrobat 7. I think.