Export report to multiple one page PDFs

[Simoquasimo]

Hi

I'm very new to Access and I've been tryin whole day to get one page PDFs from my report which contains 531 records. Idea is to make info cards out of each one row record. I can easily export pdf which contains all records but I can't manage to get one record to one page pdf.

I think I need some sort of VBA code, but I couldn't get any of those that I found from googling to work.

My database has one table which contains all the records and than I have also made on report from it where one row is roughly one A4 page.

I'm very happy if somebody can help me

 

[Pat Hartman]

You need to write the report a page at a time in order to get each page into a separate PDF. Create a do loop that reads the selected records and for each record, executes the OutputTo method to print the pdf. You will have to format the name of the pdf in your code so that each file has a unique name. To make the report select one record at a time, you need to have its RecordSource query reference a hidden form field. As you loop through the recordset, place the unique ID of the record into the hidden form field, then the query uses
Where somefield = Forms!yourform!theuniqueID;