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!!