472,962 Members | 2,937 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,962 software developers and data experts.

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

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
5 21038
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

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

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

Similar topics

by: Nicola | last post by:
Hi Everyone, I am new to programming and would like to know how to open an access Report from within vb 6. I am trying to write a program to organise cross stitch threads. I have found out how...
by: M P | last post by:
Hi! I am currently working on a project that will migrate MS Access DB and Front End to web-base solution to reduce MS Access installation. Previously, users are using MS Access as frontend to...
by: ellenh | last post by:
I have read postings on the similar subject including the posting from 2003 shown below. This process works fine to display a single page snapshot report in PowerPoint. I need to display...
by: emebohw | last post by:
Hey all, weird problem. I cant seem to get a populated text field that has a hyperlink to work when I output my access report to MS office document image writer file. If I stick a 'label' type...
by: sonicfun2006 | last post by:
I have SQL Server Database and MS Access 2003 is connected with ODBC. I have very large amount of records in various tables. The database is very dynamic as it changes every minute. Iím trying to...
by: NewDirections | last post by:
I have developed a Access 2000 database to run my business. I use it to track products, Sales, Customers, format Newsletters (select products) for mailing, and etc. What I need to do is add photos...
by: ITTrimbleKY | last post by:
Issue: I am creating a report that I want running sums in. The problem is that the field I am summing has 3 different entries that I need to sum. I have tried doing the IIF statement, but it doesn't...
by: accessdumbie | last post by:
We have a small amount of information in a Word Document that I would like to print in an Access Report. We have the location of the document for each individual record stored in a hyperlink field...
by: iheartvba | last post by:
Hi, I am trying to link a picture to an access report as follows: 1. The location of the Picure is stored as a hyperlink field in a table 2. The On Load Event of the report triggers the...
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...
by: Aliciasmith | last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
by: giovanniandrean | last post by:
The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...
by: NeoPa | last post by:
Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...
by: nia12 | last post by:
Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
by: GKJR | last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.