Access form display image from web

etech0
etech0 used Ask the Experts™
on
Hi!
I have an Access datasheet form in which I'd like to display an image for each record.
The images will all come from the same folder on our website, and the filename of the image appears in a different column of that datasheet form.
How can I accomplish this?

Thanks!
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
You can't show an image in a datasheet column.

Author

Commented:
Oh. Can I do it in a continuous form?
Commented:
Yes, in Access 2007 and newer.

1.  Create field in your table that is of type 'Attachment'.
2.  Save table and open it in datasheet view.
3.  Right-click on the attachment field for the record and choose 'Manage Attachments'.
4.  Add your attachment(s) for each record.
5.  Change your form to be continuous.
6. Create an attachment control on the form and set its control source to the newly created attachment field from the table.
How to Generate Services Revenue the Easiest Way

This Tuesday! Learn key insights about modern cyber protection services & gain practical strategies to skyrocket business:

- What it takes to build a cloud service portfolio
- How to determine which services will help your unique business grow
- Various use-cases and examples

Author

Commented:
Can I set it so that it adds each one automatically, based on the filename in another field?
All images are in the same folder on my website.

eg:

filename:                        image:
image.jpg
image2.jpg

Commented:
Here's a great example of working with attachement fields.  Let me know if this helps.

http://www.access-freak.com/tutorials.html#Tutorial07
You can show images in continuous form not only as attachments. Test example. You can insert image control to form ans set it's control source to field with file name. Open form Table1 and add path to your files
DBImagesfromfile.accdb

Author

Commented:
I don't really want the images attached at all - I want to link to them from the website.

@als315: can the same think be done with a link? I tried, but it didn't seem to work.
There are many opposites to store hyperlinks in db, but you can use it also. Change image's Control Source to:
=HyperlinkPart([HyperlinkField],0)
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
It's been a long time, but from what I remember, it is not easy to display images in Access that are "Linked" to the web.

This utility can do it, I believe:
http://www.ammara.com/dbpix/access.html

(There is a sample that you can download)

Author

Commented:
@als315: It didn't do anything. Do I also need to set the Picture property, or something?

@boag2000: Would I have to install that on each machine?
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
<Would I have to install that on each machine? >
First, ...does it work for what you need?
If not, then installation is irrelevant.

But the answer is probably Yes...
But contact them directly to be sure...

Author

Commented:
I installed it, but can't figure out where to tell it the location of the web image.
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
again, contact them directly

Author

Commented:
This product seems to be too expensive and complicated for my needs.
If I can't get a regular 'image' control to do the trick, I think I'll just wait until we switch all users over to 2010. I believe what I need can then be accomplished with a 'web browser' control.
@als315: Any ideas?
If not, I'm going to split the points between you.
Your web site is not in local network? Can you change path to files from http to some network path?

Author

Commented:
@als315: no, it's not a local network. Even if it was, I have some remote users as well. That's why web images would be the best idea.
How are you planning allow remote users connect to your DB? Access is not the best tool for remote users.

Author

Commented:
They've been doing it for years, through remote desktop.

Author

Commented:
Back to my original question, though. Any ideas on how to display web images on a form?

If not, I'm going to split points, and wait until we upgrade all users to 2010, when I'll be able to use a web browser control.
Web image will be downloaded for every user. Are you sure - it is what you want?
If it is remote desktop, why you can't make a local copy of your web site and show images from local path?

Author

Commented:
This is what I want.
Making a local copy of the site is not an option. It's too big, and constantly changing. The form will need to show current data at all times. If a specific image is missing, we'd like to know that so we can correct the filename of the product's image at that point. The data in this table will be fed into the website via CSV, and part of this includes mapping images to new products.
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012
Commented:
In a nutshell...

I know of nothing for MS Access that will do what you are asking for directly...

Perhaps there is a way, but my guess is that it would be more of a "Custom" Solution, not relay a "click here and do this" solution.

I can see using a system to download the file locally on startup, then displaying the image with a standard image control...

The kicker here is that sometimes the file location and name may change.
What is your plan for this contingency?

Author

Commented:
As I see it, once I can use a web browser control it should be fine.

The 'issue' of file locations and names changing is actually not an issue. All images are stored in one location, and will stay there. The purpose of this section of the database is to map images that are already on the web to their specific models. Therefore, if an image is missing, we'd like to notice that at this point, and correct that. Once all image names are correct (as well as a ton of other data), we'll be exporting the table to a CSV via a query, and loading that CSV to the server that feeds data into our website automatically, placing products on the website.

So the whole point is to reference the images on the web. Once we upload the CSV, the site will know which image to display for each new product based on the image filename that was uploaded.
Sync of web site with local folder is classic task and you can find a lot of products for it.
Your Access DB (if you find how to do it) will do the same (download file to local folder and show it)

Author

Commented:
The folder is huge, so syncing it is not practical. Having a web browser control download the necessary images (it'll only be a few at a time) sounds much more feasible.

Author

Commented:
Thanks to you all for your help. I'm going to be patient, and wait until we upgrade everyone to 2010. Then I can use a web browser control to accomplish what I need.
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
Also curious...?
Why the need to link to image on the site anyway?
(Is this your site or someone else's?)
If it is your site, then why cant you have access to the file directly from the web server? (Not the web Site, ...the web *SERVER*)
In other words, why go to the site to get the image and do all this crazy stuff to display and sync it, when you can get the image from the same spot that the website gets it from?

Am I missing something?

JeffCoachman

Author

Commented:
The web server is not local - we access it via ftp.
"The web server is not local - we access it via ftp."
Our web sites are also not local, but we always have local copy (very often it is source, which is copied to hosting) for testing.
I think there are free programs for downloading site content. Some paid programs:
http://www.realsofts.com/eng/wt/index.html
http://www.tenmax.com/teleport/pro/home.htm
freeware:
http://www.httrack.com/
And finally, you can download images from access:
http://www.tek-tips.com/faqs.cfm?fid=6533

Author

Commented:
Thanks. At this point, I think we're going in circles. But as I have the answer to my  question, I think we're fine.
Sometimes direct solution is not optimal and we are trying to find better way.

Author

Commented:
When we upgrade to an accdb, I'll see if using a web browser control. If not, I'll start a new thread at that point.

What's not optimal about a web browser control?
I'm not sure you can use it on continuous form.

Author

Commented:
I'll find out, I guess.

Author

Commented:
You are right, a web browser control will not work on a continuous form.
I'm going to think about this, and if necessary, repost.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial