MS Access 2010 Report - how to embed multi-page docx?

I don't believe it is possible to show anything other than a single page of the Word doc in an Access report.

I don't know any more than you regarding your second option.


You could use automation to extract all the text from the Word doc and drop that into a control in the Access report, but it would be unformatted text only.  I suspect that is not good enough.

I have not had any success getting more the a single page of another app to print on an Access report.

My solution has been to save the Access report as a PDF, save the Word Documents as a PDF, etc. Once I have creates all the PDFs I combined them together into a single PDF.

I have used several tools to do the combining. Not all are free. Here is a free tool works well:  ReportToPDF
 

<I wish to create a report, controlled by VBA, which includes selected multi-page Word docx's, dependent on certain fields in the record source. Is it possible, please?>
Can you post a specif example, ...please?


Is the Word doc "really" needed?

In other words, could you just insert the Word text into a report and do the whole thing in an Access Report?

Thanks, all. The report is based on the answers to a 30 question survey, each question having 3 possible answers. For each answer there will be an appropriate section in the report (whether an Access Report or assembly of items in a PDF) which could be 5 pages or formatted text with the odd illustration, hence the desire to concatenate Word docx's.

I need to find a way to automate the assembly of the 30 sections that are relevant to each answer set (there are 3 to the power 30 possible combinations!). I have solved the requirement to produce an Access Report with only a couple of simple paragraphs in response to each question and output them as PDFs for each respondent. The problem came when I saw the size and complexity of each of the 90 possible sections.

Your replies lead me to believe that there is no way within Access to automate the ful process. As a compromise I am proposing to create Reports with 30 short sections of simple text, each one hyperlinked to the 'full fat' version on a cloud somewhere. Any improvements on this would be appreciated.

May be it will be better to generate Word document? You can insert many documents into one and include text from your report. The you can save it as docx or export to pdf.

Thanks, als315, that is most helpful. I was coming to the conclusion that I would be better to produce a Word file rather than pdf, partly because I have found that Acrobat Reader can do strange things to hyperlinks within the document.

Having discussed my earlier 'compromise' solution, however, my client agreed that this was a much better idea that presenting a 100 page + pdf report. So I will try out your solution and report back but probably go with a summary report with hyperlinks to the full version of sections, where the reader needs more detail.

Nice workaround.

You can actually accept your own post here as the solution..
;-)

JeffCoachman

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

Please close this.