I have been successful in accessing the Mapquest maps by using a starting and
ending address, but do not have any idea how to return driving distance and
driving time to usable variables in Access. Any ideas? I am using the
following on a button:
addr1 = Replace(Me!Text32, " ", "+")
city1 = Replace(Me!Text34, " ", "+")

strurl =
"http://www.mapquest.com/maps?1c=Springfield&1s=IL&1a=120+W+Jefferson+St&1z=62702&1y=US&1v=ADDRESS&2c="
& city1 & "&2s=" & State & "&2a=" & addr1 & "&2z=" & Zip &
"&2y=US&2v=ADDRESS#mqPgSt2"
Command64.HyperlinkAddress = strurl
--
DennisT

On Thu, 13 May 2010 15:18:01 -0700, DennisT
<(E-Mail Removed)> wrote:

Most of these map providers like Google and Bing and probably Mapquest
as well provide an API you can use to get more information. Check out
their site; you will likely find information on how developers can use
the service.

-Tom.
Microsoft Access MVP


>I have been successful in accessing the Mapquest maps by using a starting and
>ending address, but do not have any idea how to return driving distance and
>driving time to usable variables in Access. Any ideas? I am using the
>following on a button:
>addr1 = Replace(Me!Text32, " ", "+")
>city1 = Replace(Me!Text34, " ", "+")
>
>strurl =
>"http://www.mapquest.com/maps?1c=Springfield&1s=IL&1a=120+W+Jefferson+St&1z=62702&1y=US&1v=ADDRESS&2c="
>& city1 & "&2s=" & State & "&2a=" & addr1 & "&2z=" & Zip &
>"&2y=US&2v=ADDRESS#mqPgSt2"
>Command64.HyperlinkAddress = strurl