Recent content by dstaple

One last question for you: I have seven different reports in this same database for which I'd like to repeat this output process . . . is there any trick to this beyond copying the module seven times and altering the code to fit the different names of the reports? Thanks for all the help!

Thanks!!! It works perfectly. I can't tell you how much time this will save me . . . many many thanks.

"Compile Error: Invalid Outside Procedure" at the Set rst line (line 3 of code) . . . Thanks for the tip on tags . . . dave

Gotcha, thanks for the help and sorry I misunderstood! I've inserted your code into the open and close events of my report and removed the page breaks. I copied and pasted the SQL from the query my report is based on, but the code isn't compiling. I'm sure I have made some kind of stupid...

Thanks for the suggestion, VbaInet . . . I took a look and may try modifying your code from that post to suit my report. However, the code I posted here is 95% functional, the only problem being that I'm getting the full report exported for each BFR Name rather than only the page(s) of the...

Hi All, I'm very new to VBA but have cobbled together the following code from a number of more experienced users online. I have a report called ITD Summary (Division) that has page breaks for each different BFR Name, and I'm trying to use this code to export each of these BFR Name sections of...