Avatar of etech0
etech0
Flag for United States of America asked on

Access form display image from web

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

Avatar of undefined
Last Comment
etech0

8/22/2022 - Mon
trbaze

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

ASKER
Oh. Can I do it in a continuous form?
SOLUTION
trbaze

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
etech0

ASKER
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
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
trbaze

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

http://www.access-freak.com/tutorials.html#Tutorial07
ASKER CERTIFIED SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
etech0

ASKER
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.
als315

There are many opposites to store hyperlinks in db, but you can use it also. Change image's Control Source to:
=HyperlinkPart([HyperlinkField],0)
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Jeffrey Coachman

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

ASKER
@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 Coachman

<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...
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
etech0

ASKER
I installed it, but can't figure out where to tell it the location of the web image.
Jeffrey Coachman

again, contact them directly
etech0

ASKER
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.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
als315

Your web site is not in local network? Can you change path to files from http to some network path?
etech0

ASKER
@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.
als315

How are you planning allow remote users connect to your DB? Access is not the best tool for remote users.
Your help has saved me hundreds of hours of internet surfing.
fblack61
etech0

ASKER
They've been doing it for years, through remote desktop.
etech0

ASKER
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.
als315

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?
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
etech0

ASKER
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.
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
etech0

ASKER
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.
als315

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)
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
etech0

ASKER
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.
etech0

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

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
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
etech0

ASKER
The web server is not local - we access it via ftp.
als315

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

ASKER
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.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
als315

Sometimes direct solution is not optimal and we are trying to find better way.
etech0

ASKER
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?
als315

I'm not sure you can use it on continuous form.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
etech0

ASKER
I'll find out, I guess.
etech0

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