Emily:
Access has no built in capability to output reports in PDF format. Normally
you have to print your documents manually to a PDF printer driver such as
Adobe Acrobat's drivers, Win2PDF (
www.daneprairie.com), pdfFactory
(
www.fineprint.com), PDF995 (
www.pdf995.com), cutePDF (
www.cutePDF.com) etc.
to output the individual reports to files.
The challenge then is to merge these files into one so you can e-mail it.
This requires either the full version of Acrobat, or using a driver like
Win2PDF which allows you to append one output to a previous output.
Access has no built in ability to do this from a command button. Some of
the drivers noted above do provide some interface so you can program them.
However, if you don't want to spend the time an energy figuring all that
out, you might check out our PDF and Mail Library for Access which can
substantially reduce the programming you have to do and time spent to
automate outputting PDF files and Mailing them. Both the Pro and Pro Plus
editions of the library support merging individual PDF files into one file
(the latter supports securing them as well as other features). You'll find
it on our web in the developer tools section.
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg
Emily V said:
I need to be able to pdf five different Access reports into one full
report for email distribution using a command button.
