I also work in a very restrictive corporate environment. I was able to
convince the network admins that there wasn't anything else available. I
print hundreds of POs per day as separate PDFs and email them to hundreds of
vendors. Everything is automated and I loop through a list using a header
file, then also have a detail file which is a subreport. Additionallly,
after creating the PDF I merge it with 2 other already created PDF files. I
use the following programs:
Win2PDF - $35 (or less in quantity)
http://www.daneprairie.com
This is, without any doubt, the very fastest PDF creator in existance. I
wouldn't use anything else, if given a choice.
PDF and Mail Class Library for Access - $99
http://ourworld.compuserve.com/homepages/attac-cg
This is delivered as an MDE file and a DLL. You simply register the dll and
set a reference to the MDE file. This code (which has been aound for about 8
or 9 years now) is continually being enhanced by its creator, Steve Arbaugh,
an Access MVP for at least that many years. The class exposes the report and
PDF objects and allows you to work with multiple versions of Outlook,
Outlook Express, or CDO.
Foxit reader - Free
http://www.foxitsoftware.com/pdf/rd_intro.php
This PDF reader runs rings around the Adobe reader. It loads itself and a
PDF file in under a second, which is at least 5 times faster than the
fastest Adobe reader with all the plug-ins stripped out.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access