Access 2010 in 2003 mode - trying to embed pdf / bmp / jpg files in Reports and Forms

I'm attempting to display different types of images in Access reports and forms. It has proven very difficult to get them to display properly. Sometimes they are sized incorrectly, fonts are distorted, opens as multiple pages even though it is only one page. I've tried both unbound object frames and image controls. The ideal would be to embed a PDF file but the sizing is not the same as the pdf file. I've converted the pdf to a bmp and jpg file but those don't display properly either.

I found one youtube video suggesting to use a web browser control but I can't find that control. I assume I will have to convert the database to 2010 mode to use it. My client has systems with older versions of Access so I can't do that.

Any suggestions?
pabrannPresidentAsked:
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.

BitsqueezerCommented:
Hi,

since A2010 the webbrowser control is part of the standard controls of Access. But that works only if you create an ACCDB in A2010 format. If you want to use this in an A2003 MDB format you need to embed the webbrowser control as ActiveX control. Click on the ActiveX control and search for the Microsoft Web Browser control and insert that into your form (I'm not sure if that works in reports also). It can be programmed nearly the same like the new internal Webbrowser control.
It's based on Internet Explorer so it's results are depending on the installed IE version and it's settings in the user's environment.

Please keep in mind that it's not a good idea to save binaries in Access databases as it let the size of the file grow very fast. In case of i.e. SQL Server you should use the Filestream method to save binaries in an external repository so that only the path is saved in the database. Instead of showing the file contents in a form or report you can then open the file using the Shell command which always uses the associated application of a file extension installed on the user's machine.

Cheers,

Christian
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
Jeffrey CoachmanMIS LiasonCommented:
Sadly, there is no way (that I know of) to easily display a PDF directly in a report.
(in a form, yes, ...but not in a Report)

I can display images just fine in Reports and Forms, so I am not sure what you mean by:
don't display properly either.
Can you post a screenshot please?

Note that a PDF is short for (P)ortable (D)ocument (F)ormat.
As a "document", a pdf contains "paging" info (page breaks, headings, ...etc)
So displaying them as "images",...may not give you what you expect.

The webbrowser (IIRC) was available in all Access versions since 2000.
But it is a bit tricky to get to it.
You need to go though the Active X option on the toolbox to open a dialog box whee the webrowser is located
See the attache images:
123
0
pabrannPresidentAuthor Commented:
Thanks so much for your help..
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.