Multiple reports from Access using Adobe Acrobat

B

b caouette

Office 2000 Pro; Win 2000 Pro/NT; Adobe Acrobat 5.0

I have vb code that prints a series of reports to the
Adobe PDF Writer. The reports are fine, the code works
fine.

The problem I'm having is that for each:
DoCmd.OpenReport "RepName", acprint, "", "" (and there are
56 of them)

I get a dialog box, opening in the appropriate
subdirectory, waiting for me to hit Enter or to
click "Save". I really don't want to sit here and wait for
each report to process then click "Save" 56 times.

The Adobe writer has an option to prompt for a save file
name that I've disabled, and I can't find anything on the
Adobe site nor in the KB on how to bypass this dialog box.

Any suggestions? (Using SendKeys to send an "{Enter}"
doesn't work because, apparently, the code gets suspended
after the acprint line waiting for an answer and doesn't
read the sendkeys command)

Thanx

bruce
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top