468,283 Members | 1,929 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,283 developers. It's quick & easy.

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

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

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

A sample piece of data is this URL:
http://www.newberrycounty.net/animal/aug16nelli3.jpg

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

REPORT
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

CODE
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
'http://www.newberrycounty.net/animal/aug16nelli3.jpg'

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).

Thanks!!
Sep 16 '07 #1
5 19874
JKing
1,206 Expert 1GB
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
Bummer!

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
MMcCarthy
14,534 Expert Mod 8TB
Have you tried linking the URL in an OLE Object type field and displaying it in a bound object frame?
Sep 18 '07 #4
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
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.

Similar topics

5 posts views Thread by M P | last post: by
reply views Thread by NPC403 | last post: by
reply views Thread by zattat | last post: by
2 posts views Thread by MrBee | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.