By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
458,114 Members | 1,570 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 458,114 IT Pros & Developers. It's quick & easy.

MS Access Report - Display a photo found at a Hyperlink URL

P: 44
Greetings, I've read some great advice on similar topics, just nothing matching exactly what I'm trying

I'm pretty close I think on making this work, but note quite there.

I want to print a report that basically displays photographs. the photographs are located on a web server viewable from my browser. I want to reference the URL and "pull" them into my report at print time

In a Table, I have a field defined as Hyperlink.

A sample piece of data is this URL:

When I click on the value in the table, it launches the photo just fine in IE.

Recordsource is the table with the Hyperlink defined
On the report, I have an Image with these properties:
NAME = image6
Picture - Value reads (None)
Picture Type - Linked
Size Mod - stretch
Hyperlink Address [empty]
hyperlink subaddress [empty]

The field with the hyperlink from the table is on the field. It is named PICTURELOCATION

In the report details "On format" event, I have this code (I also tried the 'on print' event with the same results)

Me.Image6.Picture = Me.picturelocation.Hyperlink.Address

When I open the report, I get the error run-time error '2220'
microsoft access can't open the file

I find it interesting that I can get to it from the table, but not in the report processing.

Any clear missing pieces?

One final hope is that the photo will be 'resized' nicely to fit in the size of the image on the report (in most cases, this would mean the photo has to shrink).

Sep 16 '07 #1
Share this Question
Share on Google+
5 Replies

Expert 100+
P: 1,206
Not sure if this is possible to be honest.

I know it can be done in a form as shown here at this link by microsoft Displaying images in reports and forms

The last section of the page details using a web browser object to open a URL picture.
Sep 17 '07 #2

P: 44

I do some volunteer work and the photos of the dogs can come from any one of a variety of shelters with their own websites. Each week its helpful to have one page printed with photos that can originate from as many as 10 different locations.

its easy to get to the photos, and I was hoping to eliminate the need to go through the steps to 'save' the photos to one common location. If I could just cut and paste the URL into my table and then render the report, I could get all the photos for the week on one page for this particular purpose.

Thanks in advance for any other ideas.
Sep 17 '07 #3

Expert Mod 10K+
P: 14,534
Have you tried linking the URL in an OLE Object type field and displaying it in a bound object frame?
Sep 18 '07 #4

P: 44
Have you tried linking the URL in an OLE Object type field and displaying it in a bound object frame?
Thanks for the response! I appreciate you considering my problem.

Well, I just tried to "link" to the url in an ole object and it doesn't seem to find it. Also, I believe this approach would call for several steps per entry, which i can do easily with my current MS Word approach.

What i was hoping was to just paste append a group of 10 or more URLs to a table as 10 rows and then quickly run my report. Take a 10-15 minute activity and make it about 30 seconds.

It seems thusfar the deal breaker in Access is rendering the report with the link to th URLs.

Thanks for the idea, and please tell me if I misunderstood your approach. I can send more specifics on what I was doing.
Sep 19 '07 #5

P: 1
Realize this is 3 years later, but you did ever find a solution? I'm trying to do the exact same thing but for 0000s of images.
Jul 25 '10 #6

Post your reply

Sign in to post your reply or Sign up for a free account.