Saving Report as multiple .pdfs

[Eskoraczewski]

I need help saving a report in Access to multiple pdfs. The report runs when I click the “run” button on my form. This button generates a report that is 90 pages long, and is sorted by Ownergroup_DBA. The field ownergroup_dba is on every page, and is what separates the reports. I would like to export this report to 90 different pdfs with the naming convention of “[ownergroup_dba] Premier” and have it saved to my computer. I don’t know VBA, but need to have this completed by tomorrow (of course), and I have no idea where to start! Can someone please help?

[Perceptus]

You should check out a pdf distiller that supports office integration

A PDF Distiller will convert the report into a PDF for you.

also, is this an option ?
https://support.office.com/en-ie/art...6-6f4bf7c7c110

[Eskoraczewski]

Thanks for your quick repsonse. I am looking to break up a report with 90 pages, so that each page creates a separate pdf file with a specific naming convention "[ownergroup_dba] Premier"

[Perceptus]

That sounds scary.

This looks ok. Im not too sure as I dont have any pdf's too test.
http://www.splitpdf.com/

[Eskoraczewski]

ok, is there any way to write the code in access and have this push the reports to files on my computer through the use of my database form?