How do I export an Access 2000 report as a Adobe pdf using VBA?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Stumped in New Hampshire - 30 Apr 2005 21:01 GMT

I am curently using the OutputTo method to post reports on the Web in a .snp
format. Can anyone tell me how to do the same thing with a .pdf format. I am
currently using the following code:
DoCmd.OutputTo acReport, strReportName, "SnapshotFormat(*.snp)",
strPath, False, "", 0

Reply to this Message

Douglas J. Steele - 30 Apr 2005 21:37 GMT

OutputTo will not work with PDF.

One option is to get a print driver that will create PDFs (such as Adobe
Acrobat or PDF995 or CutePDF) and print your report to that driver.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

>I am curently using the OutputTo method to post reports on the Web in a
>.snp
[quoted text clipped - 3 lines]
> DoCmd.OutputTo acReport, strReportName, "SnapshotFormat(*.snp)",
> strPath, False, "", 0

Reply to this Message

Tony_VBACoder - 10 Oct 2005 16:31 GMT

Doug, do you have any code examples without using a 3rd Party tool? I am
trying to get my code that used to work under Access 2000 with Acrobat v5, to
now work with Acrobat v6 or v7? The "PDFWriter Printer" no longer exists,
and I am trying to find some code examples using straight VBA code to output
to PDF using Access 2000.

> OutputTo will not work with PDF.
>
[quoted text clipped - 8 lines]
> > DoCmd.OutputTo acReport, strReportName, "SnapshotFormat(*.snp)",
> > strPath, False, "", 0

Reply to this Message

Douglas J. Steele - 10 Oct 2005 16:54 GMT

No version of Access have PDF capabilities built into it (although they will
be added in Access 12), therefore you have no choice but to use a 3rd party
tool.

Take a look at what Steve Arbaugh has at
http://ourworld.compuserve.com/homepages/attac-cg/

Or, if you hold on a week or two, Stephen Lebans will be releasing a class
that'll be capable of generating PDF.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Doug, do you have any code examples without using a 3rd Party tool? I am
> trying to get my code that used to work under Access 2000 with Acrobat v5,
[quoted text clipped - 17 lines]
>> > DoCmd.OutputTo acReport, strReportName, "SnapshotFormat(*.snp)",
>> > strPath, False, "", 0

Reply to this Message

Jeff Conrad - 10 Oct 2005 23:03 GMT

> Or, if you hold on a week or two, Stephen Lebans will be releasing a class
> that'll be capable of generating PDF.

I thought that was NDA.

:-)

Signature

Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html

Reply to this Message

Ofer - 30 Apr 2005 22:27 GMT

I had the same question and that what I got, th export as pdf, try it, it
worked for me.

Take a look at http://www.granite.ab.ca/access/pdffiles.htm.
or
The snapshot format includes a viewer you can send with
your report the
first time (for those who don't have Access) There are
several free pdf
creators available too. Just google for: CutePDF or PDFCreator

There are several. You'll need GhostWriter and the print
driver. Have a look
at http://www.cutepdf.com for one of them. Others at:

http://www.pdf995.com/
http://www.primopdf.com/

> I am curently using the OutputTo method to post reports on the Web in a .snp
> format. Can anyone tell me how to do the same thing with a .pdf format. I am
> currently using the following code:
> DoCmd.OutputTo acReport, strReportName, "SnapshotFormat(*.snp)",
> strPath, False, "", 0

Reply to this Message