Exporting Reports To MS Word

[CarlM1975]

Hi there

I have a database that contains around 6 or 7 reports. I want to be able to output these from the click of a button into MS Word. Now I can easy do this by creating a word doc for each report but ideally I would like to have all 6 or 7 reports in the same word doc. with each report starting on the next blank page. Is this possible and if so what would be the code?

Many thanks for any help

Carl.

 

[DCrake]

Create a new report in Access and add all the reports as subreports into the outer report footer section. Next set the footer properties to page break after each report.

Then call the outer report

This is all from memory so you will need to check my logic but the principle is correct.

 

[CarlM1975]

Is the outer report footer section just the "report footer" I also can not work out how to page break after each report, I think I may be putting the sub reports in the wrong place.

 

[DCrake]

You could actually insert a page break control between each report if needed.

 

[CarlM1975]

Ok, how would I do this?