Marco to split up and save a report

[jjsaw5]

Hello,



I’m looking for some assistance with an enhancement we are looking to complete with one of our Access DB’s. Here is some information on the database and what we are trying to do.


Currently : We have a report that is run for some of our invoices, this report is currently printed out and then manually scanned into another system. Each invoice is one page, and all the invoices are the same layout just the data on them is different.

Future: What I would like to do is create a macro or something that will allow this report to be saved to a directory and split each invoice into its own PDF file and then our imaging software can pick up the files from that directory and digitally scan them into our system. I’d like to eliminate the printing and manual scanning of these invoices.

Has anyone ever created anything like this before? I would greatly appreciate any assistance anyone could provide me with this issue.

So again I’m looking to create a macro or piece of code that the user can push a button and have the invoices saved to a directory as separate files.

[June7]

I doubt Access VBA could be used to split up a pdf. Could use VBA to individually output to pdf each page of the report. Actually, probably have to code so each page opens as a single document (filter report to one customer at a time). This would be accomplished by opening a recordset of the customers, loop through recordset to grab customer ID, open filtered invoice report, send to PDF, repeat.