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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jeffrey CoachmanMIS 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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Nicola SiottoDirectorAuthor Commented:
It's not exactly what I wanted but it partially solves the issue. Thank you!
0
Jeffrey CoachmanMIS LiasonCommented:
OK
0
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.