Access 2003 Report - vba to loop through records in query and save each as a separate report
Posted on 2009-04-08
I need help with the vba loop to produce an individual report for each record in a query.
I have a report named rptMissingReports based on a query named qry_rpt_MissingReports. The report currently has a page break for each record in the query. So, if there are 50 records in the query, there are 50 pages in the report. I would like to save (print to pdf) each page as a separate report.
Rather than prompt the user for a file name each time a pdf is generated, I'd like it to save to c:\temp\ with a file name comprised of 2 of the field names - [name]_[number].pdf