Embed a PDF file into page 2 of a report

I have been asked to create a Job Card (Report) from an existing database - done no trouble. But now they want it to find and display a plan of the location (pdf) on page 2 of the report (must be page 2 because it has to print on the reverse side of a double-sided form). I can programatically work out the location of the plan (P:\CustomerName\JobNum\SitePlan.pdf) easily so all I need to work out is how what object type I need to use and how to set it up so that the pdf will display on page 2 of the report. A complication is that the plan is in A3 and the form it needs to print on is A4 so it needs to be scalable. Is this possible and if so how?
Rob4077Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jeffrey CoachmanMIS LiasonCommented:
In all my time with Access, I have never found an easy way to do this.

You can do it in a form by using a webbrowser control and pointing it to the PDF file.
...but not in a report.

Alternatives:
1. You can try using the adobe sdk/vba libraries, ...but documentation may be scarce.
http://www.adobe.com/devnet/acrobat/downloads.html

2. You can use a utility to "batch convert" the PDF's to images, ..then the image of the PDF can easily be displayed on the report.

3. Print the form instead of the report. Then, again, you can use a webbrowser control on the form that points to the PDF, then use the Page break control to display the PDF on the second page.  Note the with this technique, ...it may be hard to control how the form Prints.

Let me know...

JeffCoachman
0
Rob4077Author Commented:
Hi Jeff, you said "use a utility to "batch convert" the PDF's to images". Where would I find such a batch utility? I may be able to get VBA to initiate the conversion, include the image in the report, then delete the created image.
0
Jeffrey CoachmanMIS LiasonCommented:
There are many, ...you can do a Google search:
https://www.google.com/?gws_rd=ssl#q=batch+convert+PDF+to+image

The kicker here is that if the PDF's need to be "Updated" regularly, ...then you need to keep converting them as well.

but lets go back a bit.
Conversion is not needed at all, if you tried using a form.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Rob4077Author Commented:
Hi Jeffrey, Sorry I missed your last comment until now. So are you suggesting that I convert my report to a form, then use a webbrowser control on the form that points to the PDF, then use the Page break control to display the PDF on the second page? Doing it that way, means I only lose the CanGrow Can Shrink functionality - makes sense. And a web browser control will display a PDF I assume? I will give it a go.
0
Rob4077Author Commented:
Hi Jeffrey, I created a form, used a webbrowser control and the form displays correctly with the PDF image. Here's the code I used on the draft form to get it to display the PDF on screen perfectly.
Forms![frmJobCard].WebBrowser0.Navigate2 ("P:\Aussie Living\2 Sansimeon Byford\1413146_1100719.pdf")

However when I print or print preview the webcontrol just displays and prints as a frame with nothing in it. How do I get around that?
0
Jeffrey CoachmanMIS LiasonCommented:
what version of Windows/Office are you running?
0
Rob4077Author Commented:
Office 2013 (some PCs running 2013 Runtime Office) on Windows 7
0
Jeffrey CoachmanMIS LiasonCommented:
Oh,

Sorry, I confused "View" with "Print".
So, again, ...there is no direct way to do this in Access.

You may be able to glean something from the Adobe SDK, about using the Adobe ActiveX control (if you purchase the full version of Adobe)
http://www.adobe.com/devnet/acrobat/downloads.html

JeffCoachman
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Rob4077Author Commented:
Thanks for taking time to try to help. At least I know. Appreciate the effort
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.