Create PDFs w/o prompting

[Razor]

Hi,

I have a form that allows a user to supply a 'WHERE'
filter through a listbox and then write out a report to
PDF.

The report goes to PDF because its printer setting is set
to the PDF printer, but not before it prompts the user for
a filename.

I have two questions:

1. Can I set the PDF's filename though code?
2. Can I generated PDFs for all the items in the listbox
without user intervention?

In essence, I want to leave the process running overnight
and find all the PDFs the next morning.

Thanks,
Razor

 

[Cheryl Fischer]

Razor,

I think you'll need an add-in to do the items you listed. I have been very
pleased with the ACG Soft Mail Class and PDF Library.

http://ourworld.compuserve.com/homepages/attac-cg/

There are other products out there that automate creating PDF Files of
Access reports, so you may want to do a search in Google for them.

hth,

 

[Chris]

No add-in needed:


http://www.mvps.org/access/reports/rpt0011.htm


Chris