I am printing out a report from visual basic to pdf format. Is there a way
to append the report to an existing PDF file if one already exists with the
same name?

Thanks

Ken C.

On Sat, 4 Jul 2009 10:57:01 -0700, krcmd1
<(E-Mail Removed)> wrote:

THere is nothing built-in, but you may be able to use a tool like
Stitcher that can put several PDF files together as one.

-Tom.
Microsoft Access MVP


>I am printing out a report from visual basic to pdf format. Is there a way
>to append the report to an existing PDF file if one already exists with the
>same name?
>
>Thanks
>
>Ken C.

"krcmd1" <(E-Mail Removed)> wrote in message
news:F9020CB5-80C0-4BB5-88D3-(E-Mail Removed)...
>I am printing out a report from visual basic to pdf format. Is there a way
> to append the report to an existing PDF file if one already exists with
> the
> same name?
>

You don't mention what version of ms-access. However, if you use Stephan's
code, it not only eliminates the needs to install a pdf printer driver, but
it also has the ability to merge pdf files...

You can find this example + utility here:
http://www.lebans.com/reporttopdf.htm


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
(E-Mail Removed)