Snapshot to PDF

[Chris]

Hi,

Is there a routine or method by which an Access report can be written to an
Adobe Acrobat (via Snapshot formatting)? I'm familiar with the way to use
DoCmd.OutputTo to send to the various standard formats; any way to do this
with Acrobat (assuming the Writer/Instiller is installed).

I keep experience a reticent user population which doesn't want to
download/use the Snapshot viewer, and the .RTF format isn't sufficient for
my output because they employ line draw.

Chris

 

[Rick Brandt]

Hi,

Is there a routine or method by which an Access report can be written to an
Adobe Acrobat (via Snapshot formatting)? I'm familiar with the way to use
DoCmd.OutputTo to send to the various standard formats; any way to do this
with Acrobat (assuming the Writer/Instiller is installed).

I keep experience a reticent user population which doesn't want to
download/use the Snapshot viewer, and the .RTF format isn't sufficient for
my output because they employ line draw.

Most PDF "writers' act as a virtual printer. You simply print the Access report
to that printer and you get a PDF file. Trying to make all of that automatic is
harder though and usually requires a software solution that you will have to pay
for.

 

[Chris]

NEVER MIND.

I've been using Outlook Express to search this group, and it never finds
anything. When I went to the MSIE version, I fould the history on
using/outputting PDF files.

Chris

 

[James]

yes, check out Ken Getz's solution

Basically identify and save the default printer.
Change to the Adobe printer.
Use the Docmd.Open Report (specify report name *.pdf)
After "printing" which is really just generating the file switch back to
previous
default printer.
You could run into a problem depending on the version of Adobe you are using
5.0 is straightforard, later versions can be problematic.
Also if you dont want the Save As dialog box to come up you will need to
create a registry value for PDFFileName, specify full path to the pdf

 

[SA]

Chris:

Our PDF and Mail Library for Access can automate output of your Access
reports to the PDF format (all via code, no user interaction required,)
using any of eight different PDF printer drivers including Adobe Acrobat.
You'll find it in the Developer Tools section of our web site.