I'm having a problem sending Access Reports, via Acrobat PDF Writer, to a folder - I get the error: Unable to create output file, job canceled. But I only get it the first time I run it (I think that day but I need to check on that) and after that it works fine. This wouldn't be a problem but I'm creating reports for about 400 stores at a time (via a query) and don't want to click on ok 400 times everytime to get through all the errors so it will then work.
I'm using version 3.01 of Acrobat. The part of the code that might be causing the trouble is below but I'm not sure if this will be enough to help.
SetPDFParms 0, sPDFName
DoCmd.OpenReport sReportName, , , "[STORE] = " & rs!Store
SetPDFParms 0, ""
Thanks for any assistance you can give me!
I'm using version 3.01 of Acrobat. The part of the code that might be causing the trouble is below but I'm not sure if this will be enough to help.
SetPDFParms 0, sPDFName
DoCmd.OpenReport sReportName, , , "[STORE] = " & rs!Store
SetPDFParms 0, ""
Thanks for any assistance you can give me!