Export individual report to pdf
Posted on 2017-05-15
I have an Access 2007 database with 300 results from a survey, each of the 300 people surveyed answered a dozen questions which are being analysed.
What I also need to do is produce a separate pdf report for each person surveyed (each person's results are between 1 to 2 pages in length) ie 300 different pdfs.
The results are all housed in a table called "FinalResults" and are fed through to the report from a query called "IndividualReportQuery". The report itself is called "Individual Report" and there is a unique ID for each record called "ID" which is what I would like to use as the name for each pdf.
I have thought of exporting the whole report as a pdf & then use a pdf splitter, but each record can be 1 or 2 pages in length.
The only other way I was thinking was to somehow use a recordset clone ... basically create a query for the 1st record in the report (ie select all from XXX where ID = "123456") & use this as the dataset for the report. Then export the report, once done then the last bit of vba would be to delete the newly created query and repeat this process 300 times.
Can anybody help or have other ideas of how to tackle this?