Create Separte file or report for each Break

[Byron]

I have a report that has a page break on every new Name code.

Is it possible to create a macro that would actually create a new report for each Name Code.

Currently the report generates a new report page on each name code. How can I create a separate file or report for each Name Code?

 

[Russell Hauf]

What is your ultimate goal? Why do you need a separate report for each code?

Thank you,

Russell

 

[Byron]

Because I need to send a separate file for each person's review to a client electronically.

 

[Byron]

Because I need to send a separate file for each person's review to a client electronically.

 

[Russell Hauf]

What I would do is to call the report from VBA for each code. To do this, I would create a query that groups by your code. Then I would open that query in a recordset, and open your report with a filter for each group while looping through the recordset - saving or emailing it as you go.

Check the arguments for DoCmd.OpenReport to see how to open a report for only one code (WhereCondition).

Let us know if you need further help, and what you want to do with each report once you've opened it (do you want to save it, do you want to email it as you go...).

HTH,

Russell

 

[Ssusanns]

OK, I need to do the exact same thing. I have a report listing various companies. Each company on the report has a separate page. I need to save each page as a separate report to e-mail to the company.

I am not a programmer, so I don't understand the instructions above. Can you dumb it down a bit for a regular user? I am totally lost.

- Susan