Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    Feb 2003
    Posts
    144
    Thanks
    0
    Thanked 0 Times in 0 Posts

    URL in a report (2002)

    I need to know if something is possible. I want to include a map, sourced from mapquest or yahoo, in my report. The report would have the address, city, state, and zip code data that I would need to pass to map site. Can I have the picture property for an image control set to the URL of the map site and have the actual map printed in the report? Any advice would be greatly appreciated.

  2. #2
    New Lounger
    Join Date
    Oct 2002
    Location
    Perth, Western Australia, Australia
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: URL in a report (2002)

    I would be inclined to have a look at the address bar when you are entering a map to see if you could create a string that would match what they would create in the menu bar. Once you have that right you should simply be able to use this string as your URL and it should bring up the map. I am not sure whether it will be possible to get it back down into access but you will at least be able to display the map.

    Hope this helps.

    Vicki

  3. #3
    2 Star Lounger
    Join Date
    Feb 2003
    Posts
    144
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: URL in a report (2002)

    Vicki,

    Thanks for the response. I can programmatically generate the mapquest URL for each property that I need to map and store it as a string in the database. What I'd like to be able to do is create a form that displays each property, the maquest url, and the path and file name for the map image I want to save. Then some how use a keyboard/mouse macro, triggered from an access event, to do the following:

    1) open a browser session,
    2) copy and paste the URL, displayed in the access form, into the browser window.
    3) once the map is displayed, right click on it and click on save as.
    4) the path and file name would be copied and pasted, from the access form, into the save as dialog box.
    5) close the browser window
    6) go to the next record until completed.

    Then I could set the picture property of an image control in a report to the map image saved in step 3. I used some macro software, back in the Windows 3.1 days, that allowed you to capture keyboard and mouse strokes, then execute the steps based on a set of criteria. Whether or not something like that still exists, I'm not sure. Anyone think this is feasible or am I just completely way off here? <img src=/S/crazy.gif border=0 alt=crazy width=15 height=15>

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: URL in a report (2002)

    Steps 1) and 2) are easily achieved with one instruction:
    Application.FollowHyperlink strURL
    where strURL is a string variable containing the web address.

    The rest is much more complicated, since it takes place outside Access. Even if you have a Windows macro recorder, it is tricky, because I don't know whether all browsers have the same popup menus; screen and browser settings will also influence this.

  5. #5
    2 Star Lounger
    Join Date
    Feb 2003
    Posts
    144
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: URL in a report (2002)

    Hans,

    The application that would gather the map images would always run from the same machine, so I may be able to maintain consistent browser windows, pop-ups, etc. If I can get past the brower issues and can find macro software that would allow me to perform the browser navigation, which I know are two BIG ifs, is there a access event that might allow such a macro to be executed when the form receives a new record?

    As always, thanks for your help.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: URL in a report (2002)

    You'd probably do that in the AfterUpdate event of the control containing the URL - if the URL has changed (in particular, if it has just been entered in a new record), you need to fetch the image and store its path in the record.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •