[AccessD] Generate Access Report to Two PDF files / or How to Copy a File with VBA code in Access

Brad Marks BradM at blackforestltd.com
Sat Apr 7 11:30:58 CDT 2012


All,

We have an Access application that is run automatically every night.

It generates an Access report to a PDF file.

There is now a need to automatically create two copies of this PDF file in two different folders.

What is the best way to generate the first copy and then copy the first copy to a second copy with a different file name?

(Did anyone catch how I used the word “Copy” 4 times in one sentence?  :-)

Thanks,

Brad



More information about the AccessD mailing list