JMS,
You didn't mention which version of Access you are using and whether you
have Adobe Professional, or another PDF generating application available.
THIS ONLY APPLIES (IN PART) TO PRINTING TO PDF PART OF YOUR QUESTION:
There are several other posts out here with useful information. I will take
a stab at getting you started, with the assumption that you have Adobe and
are using Access 2003.
1. Select the report(s) you are wishing to output to PDF format, using File>
Page Setup>, on the Page tab...
a) Select radio button "Use Specific Printer"
b) Select "Printer" button and select "Adobe PDF" (or other app, if
appropriate).
If needed, setup the properties, and click OK.
c) Click OK. (This will set the default printer to be your PDF file
generation)
2. Repeat #1 for each report you need to print to (convert to) PDF on output.
3. In your code, you can use:
DoCmd.OpenReport "YourReport", acViewNormal
The database to print your report(s) using your defined default (to a
PDF file) and ask you to select where and what file name you wish to deliver
it as.
Unfortunately, I have not yet figured out a way in AC2003 where I don't have
to manually set the printer default and can't program where and what file
name to deliver it to.
While this may not be a TOTAL solution, perhaps someone else can come up
with a more correct solution. I know I would welcome it too. Good luck.
