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

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,

--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX


"Razor" <(E-Mail Removed)> wrote in message
news:11faa01c3f55f$bbb38af0$(E-Mail Removed)...
>
> 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
>

No add-in needed:


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


Chris


>-----Original Message-----
>
>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
>
>.
>