MS Access 2007 - Source picture from url and aggregate with a field content

I have a field where it's stored an IP address. Then I found a link that if aggregated with the IP at its end it will show image with relevant country flag.

So how do I show this image in the form?

I believe best way would be an Activex function but here's where I stop.

Thanks for any help.
Nicola SiottoDirectorAsked:
Who is Participating?
 
Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:
nsiotto,

Your terminology is confusing:

"Then I found a link"
If you mean link, as in web Page link, then can you post this "Link" here?

"if aggregated with the IP at its end"
Don't you simply mean "Add" instead of "Aggregate"?

" Activex function "
There is no such thing, there are ActiveX "Controls"

Displaying an image on a form is easy.

If you have a textbox that contains the IPAddress, the full path, filename and file extension.
For example:
    //192.168.1.1/YoufFolder/USAFlag.jpg

You can display the image on the form by:
Naming this TextBox something like: txtFlagImageLocation
Inserting an "Image" control on the Form, from the Controls Toolbox.
Name this image control something like: imgCountryFlag

On the Current event of the from put code like this:

  Me.imgCountryFlag.Picture=txtFlagImageLocation

Give this a try by yourself.

Let me know if you are having any issues.

JeffCoachman
0
 
Nicola SiottoDirectorAuthor Commented:
It's not exactly what I wanted but it partially solves the issue. Thank you!
0
 
Jeffrey CoachmanMIS LiasonCommented:
OK
0
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

 
nuritatCommented:
Hi

I have the same problem and I tried that

Me.Image18.Picture = "http://www.mysite.com/images/img_2817.jpg"
but I get an error : Microsoft Access can't open the file : http://www.mysite.com/images/img_2817.jpg

How can I resolve this?

Thanks

0
 
Jeffrey CoachmanMIS LiasonCommented:
@nuritat
You cannot do this with a textbox (view an image from a website)

You must use a webbrowser control
See this link:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_27112466.html
0
 
Jeffrey CoachmanMIS LiasonCommented:
Besided, ...your link:

http://www.mysite.com/images/img_2817.jpg

...is dead anyway...
...perhaps that has something to do with this?
0
 
Jeffrey CoachmanMIS LiasonCommented:
0
 
nuritatCommented:
Thank you very much, you already answered perfectly to this question that I opened for this issue (I didn't know discussions can be reopened)

the link was dead because it was only  the format of what I wanted, not a real one

anyway
 thank you very much
0
 
Jeffrey CoachmanMIS LiasonCommented:
ok

;-)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.