Automate report output to PDF

[Bryan Haas]

I am trying to use a scheduled macro to output reports in
PDF (the requirement is PDF and not snapshot). I have
the reports set to print to PDF but when I schedule the
macro it prompts to output and needs a name. Two
challenges - (1) how can I bypass this or set a default
(2) if #1 can be done, how can I avoid getting prompted
about an overwrite. Thank you!

 

[Steve Schapel]

Bryan,

This is really more to do with your PDF writer than with Access. Some
PDF printer drivers offer automatic naming of files, for example I use
PDF995 and this is the case. If your PDF printer driver does not offer
the flexibility you need, you will have to look at writing VBA
procedures to get what you want, as this will not be possible with macros.

 

[Bryan.Haas]

Thank you for your prompt response!

-----Original Message-----
Bryan,

This is really more to do with your PDF writer than with Access. Some
PDF printer drivers offer automatic naming of files, for example I use
PDF995 and this is the case. If your PDF printer driver does not offer
the flexibility you need, you will have to look at writing VBA
procedures to get what you want, as this will not be possible with macros.

--
Steve Schapel, Microsoft Access MVP



.