Internet Photo on Form

[billharrison9]

Is there a way to insert an image from the Internet onto an Access 2003
form?

Here's the background:
I need to place employee photos onto a form that displays information
about them.
The photos are only available over our intranet.
Each photo's URL uses the employee's ID number, so I can easily
reference the right URL
I want to call the image from the Web rather than trying to include the
photos into the DB.

I know I could call the images from a local directory, but how do I
insert Web images onto a form?

Thanks!

 

[Guest]

Hi Bill

If your photos are on your company intranet then they must be stored on the
server in a source file. You can simply use this file as the source for the
photo link on your "emplyee" table (or what-ever you call it).

The main problem you will have is that is it almost certain that your
intranet picture will not be the right size for your OLE box on the access
form/page. You may need to link the internet photo server file with another
and re-sample all the pictures in the new file - use this new file as your
source.



Hope this helps.

 

[bob]

Yes – add a “Microsoft Web Browser control” and use the .Navigate or .Navigate2 methods to go to the appropriate
url (do this in the form’s OnCurrent event).

Note that unlike the Access Image Control and OLE Frames, the web browser control does not (AFAIK) permit
scaling the image to fit, so in this case you really would have to create resampled (i.e. resized) images
if they were too big for the control area and you wanted to avoid scrollbars.