Results 1 to 6 of 6
  1. #1
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5

    Unanswered: Hyperlink to Mapquest and Insert address

    New one for me. Does anyone know how to create a hyperlink on a form (I know that part) to mapquest and then insert the address into the controls (address) on mapquest?
    Dale Houston, TX

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Are you suggesting changing the HyperLinkADdress property dynamically. This will only work for pages that pass the querystring in the URL...

    For example, google uses the following
    http://maps.google.com/?ie=UTF8&hl=en&q=kansas+city&f=q&ll=39.185433,-94.584045&spn=0.940966,1.867676&z=9&iwloc=addr&om= 1
    And will work with just this
    http://maps.google.com/?ie=UTF8&hl=en&q=kansas+city

    So in theory you shold by able to build up the address through VBA by working out the query string

    Or am I barking up the wrong tree?
    George
    Home | Blog

  3. #3
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5

    I think I sort of maybe understand a little

    Hey Geo

    With the code that you have provided the links if inseted through the toolbox are on a label

    should I use the properties of the hyperlink and do something like

    http://maps.google.com/?ie=UTF8&hl=en&q= & me!mylistbox.column(4) & +city

    or would I shell to internet explorer and then pass in the variables?

    also for address city and state would It look like
    http://maps.google.com/?ie=UTF8&hl=en&q=mycity + city , mystate + state
    Dale Houston, TX

  4. #4
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5

    Thank you Geo - I made a small change - this works great

    Dim myaddress
    myaddress = lstorders.Column(4) & " " & lstorders.Column(5) & ", " & lstorders.Column(6)

    Me!cmdMap.HyperlinkAddress = "http://maps.google.com/?ie=UTF8&hl=en&q=" & myaddress
    Dale Houston, TX

  5. #5
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Well done Dale, and thanks for posting the solution!
    George
    Home | Blog

  6. #6
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5
    thanks for the kickstart Geo
    Dale Houston, TX

Posting Permissions

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