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

Posted on 2008-11-07
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.
Question by:nsiotto
    LVL 74

    Accepted Solution


    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:

    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:


    Give this a try by yourself.

    Let me know if you are having any issues.


    Author Closing Comment

    It's not exactly what I wanted but it partially solves the issue. Thank you!
    LVL 74

    Expert Comment

    by:Jeffrey Coachman

    Expert Comment


    I have the same problem and I tried that

    Me.Image18.Picture = ""
    but I get an error : Microsoft Access can't open the file :

    How can I resolve this?


    LVL 74

    Expert Comment

    by:Jeffrey Coachman
    You cannot do this with a textbox (view an image from a website)

    You must use a webbrowser control
    See this link:
    LVL 74

    Expert Comment

    by:Jeffrey Coachman
    Besided, ...your link: dead anyway...
    ...perhaps that has something to do with this?
    LVL 74

    Expert Comment

    by:Jeffrey Coachman

    Expert Comment

    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

     thank you very much
    LVL 74

    Expert Comment

    by:Jeffrey Coachman


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    The first two articles in this short series — Using a Criteria Form to Filter Records ( and Building a Custom Filter ( — discuss in some detail how a form can be…
    A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
    Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    759 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

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now