?
Solved

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

Posted on 2008-11-07
9
Medium Priority
?
714 Views
Last Modified: 2013-11-28
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.
0
Comment
Question by:nsiotto
  • 6
  • 2
9 Comments
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 1500 total points
ID: 22911023
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
 

Author Closing Comment

by:nsiotto
ID: 31514450
It's not exactly what I wanted but it partially solves the issue. Thank you!
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 23294750
OK
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 

Expert Comment

by:nuritat
ID: 36017733
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
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36019738
@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
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36019837
Besided, ...your link:

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

...is dead anyway...
...perhaps that has something to do with this?
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36019885
0
 

Expert Comment

by:nuritat
ID: 36024236
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
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36027012
ok

;-)
0

Featured Post

Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question