Web images on Access Form? 1

[GigglettesDad]

Greetings:
I have a client who is a graphics artist. She has about 5000 URLs of images from a large variety of websites currently stored in an Access 2007 database. She has these categorized in a way that she can call up a subset of these URLs. She assures me that all of the images are from image morgue files, or images that are free to copy and use as long as you don’t make changes to the images. What she wants to do is continue collecting the URLs and have Access display the images on an Access form. An example URL is:

http://www.morguefile.com/data/imag...review/fldr_2009_05_02/file6071241272655.jpg.

I can handle the forms, etc. but I haven’t found a way to take that URL and attach it to an image field. Here’s what I need:
• Is there a way to have an Access Form Image Field display an image from an URL?
• If not, is there any VBA code that will allow me to copy the image locally from the URL?
(I have already written VBA code that displays local images so I just need to know how to get the image copied locally)

Thanks,
Randy

 

[ZmrAbdulla]

can insert a webbrowser control on a form to view the pictures

INSERT > ACTIVEX CONTROLS > MICROSOFT WEB BROWSER

then
either

Me.WebBrowser1.Navigate "[URL unfurl="true"]http://www.morguefile.com/fldr_2009_05_02/file6071241272655.jpg"[/URL]

using the exact url
or

Me.WebBrowser1.Navigate Me.Text2.Value

You can use the same method for local images too.


Zameer Abdulla

 

[GigglettesDad]

Zameer:

Thanks for the reply - I didn't realize that the Web Browser ActiveX control could do that - thank you very much!