[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

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

Posted on 2011-05-11
11
Medium Priority
?
1,464 Views
Last Modified: 2013-11-28
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?

I will export the report as a .pdf file, so an alternative way to work would be to 'concatenate' the report with a selection on docx's and export the lot as a .pdf file - but I have no idea how to do that, either!
0
Comment
Question by:bexvlad
10 Comments
 
LVL 77

Expert Comment

by:peter57r
ID: 35736885
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.
0
 
LVL 21
ID: 35738345
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
 

0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 35739504

<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?
0
Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

 

Author Comment

by:bexvlad
ID: 35744267
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.
0
 
LVL 40

Expert Comment

by:als315
ID: 35763057
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.
0
 

Author Comment

by:bexvlad
ID: 35763316
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.
0
 

Accepted Solution

by:
bexvlad earned 0 total points
ID: 35878030
For what it's worth to others, I ditched the attempt to combine all these files and went for a summary Report with brief information and links to full info as either .doc or .pdf on the web server.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 35897592
Nice workaround.

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

JeffCoachman
0
 
LVL 93

Expert Comment

by:Patrick Matthews
ID: 36157651
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
 

Author Comment

by:bexvlad
ID: 36153734
Please close this.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Office 365 is currently available in five editions. Three of them are for business use: Office 365 Business Essentials, Office 365 Business, and Office 365 Business Premium. Two of them are for home/personal use: Office 365 Home and Office 365 Perso…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question