Others

How to Save Each Access Report Page as a Separate PDF File

Emma Brown Oct 7, 2026 869 views

Question details

The user needs to export a Microsoft Access report in such a way that each grouped section is saved as an individual PDF file.

How to Save Each Access Report Page as a Separate PDF

Product: Microsoft Access
Device & OS: not provided
Scenario: Exporting grouped database reports to distribute individual records or invoices to different clients.
Observed behavior: The goal is to automatically split the report and save each page or grouped section as its own PDF, rather than generating one large PDF containing all records.

Before you start

Ensure your Access report is correctly grouped by the desired field (e.g., Customer ID) and that you have a basic understanding of using VBA modules in Microsoft Access.

Solution 1Recommended

Use Report Grouping and VBA to Export Separate PDFs

Group your report by the required field, force a page break, and use a VBA script to filter and export each group individually.

Microsoft Access does not have a native button to split reports into multiple PDFs automatically. The most effective method is to define a group in your report design, enforce page breaks after each group, and then use a VBA macro to loop through the records and export them one by one.

Group the report by the required field

Open your report in Design View. Open the Group, Sort, and Total pane, and add a group based on your target field, such as Customer ID.

Force a page break after each section

Select the Group Footer (or Detail section), open the Property Sheet, find the 'Force New Page' property under the Format tab, and set it to 'After Section'.

Open the VBA Editor

Press ALT + F11 to open the Microsoft Visual Basic for Applications (VBA) editor. Click 'Insert' and select 'Module' to create a new script area.

Write the VBA loop and export script

Write a VBA script that opens a recordset of your grouped field (e.g., all unique Customer IDs). Use a loop to iterate through this recordset, applying a filter to the report for the current ID, and execute the DoCmd.OutputTo command using acFormatPDF to save the file with a dynamic name.

Run the VBA macro

Save your VBA code, close the editor, and run the macro. Access will loop through your data, filter the report for each group, and export them as separate PDF files to your designated folder.

Use Report Grouping and VBA to Export Separate PDFs

VBA Customization: The specific VBA code will depend on your table names, report name, and field names. Ensure you replace any placeholder variables in your script with your actual database schema.

Free Microsoft Office alternative

Easily Split Exported PDF Reports with WPS Office

If you prefer not to write complex VBA code in Microsoft Access, you can export your entire report as a single PDF and use WPS Office to instantly split it into individual pages. WPS Office is a free, lightweight suite offering robust PDF tools and seamless Microsoft Office format compatibility.

1. Export the Access Report as a single PDF: Use the standard 'External Data' tab in Microsoft Access to export your grouped report as one large PDF file.
2. Open the PDF in WPS Office: Launch WPS Office and open the exported PDF report.
3. Split the PDF by page: Navigate to the 'Page' tab on the top ribbon and select 'Split PDF'. Choose to split the document by every 1 page (or your specific page count) and click 'Split' to generate separate files.

Easily split large PDF reports into separate pages with WPS PDF without any coding.High compatibility with Microsoft Word, Excel, and PowerPoint file formats.Free, lightweight, and fast-loading alternative to Microsoft Office.Built-in PDF editor for annotating, signing, and converting your database exports.

microsoft office alternative - wps office

Frequently Asked Questions

Can I split an Access report into separate PDFs without using VBA?

Microsoft Access does not have a built-in feature to automatically split and export grouped reports into separate files. You must either use VBA code to automate the process or export the entire report as a single PDF and use a PDF editor (like WPS PDF) to split it.

Why is my Access report exporting as one large PDF instead of multiple files?

By default, the DoCmd.OutputTo command and the manual Export to PDF button process the entire active report. To export multiple files, you must use a VBA loop to filter the report for each specific record or group before triggering the export command.

How do I force a new page for each customer in an Access report?

Open your report in Design View, select the Group Header or Group Footer for the customer field, open the Property Sheet (F4), and set the 'Force New Page' property to 'After Section' or 'Before Section'.

Office Quick Solutions