Calculate Driving Distance Between 2 Coordinates (1 Viewer)

[fbcma]

I am using Access 2013 and am developing a form where the user provides two coordinates.
And the form will calculate the driving distance between these 2 coordinates.
I'm not sure where to start. Any input/sample would be greatly appreciated. Thanks.

 

[plog]

Geometry would give you the distance between 2 points, but you want driving distance which is going to require a map. I'd check out the google map API:

Google Maps Platform Documentation | Google for Developers

Google Maps Platform Documentation

developers.google.com

I've only done a cursory google search ('driving distance in google map api'), but it looks like others have tried to tackle this.

 

[fbcma]

What about Bing API?

 

[plog]

Sure.

 

[Gasman]

This thread might help?

calculate the driving distance between 2 zip codes

I import information pertaining to a shipment. I have to calculate the driving distance between 2 zip codes. Currently I go to mapquest, enter the two zip codes, then paste the distance within my DB. I've looked at applications that calculate the distance, but they do not calculate driving...

www.access-programmers.co.uk

 

[isladogs]

You can also 'cheat' by using a form which loads the Google (or Bing) route planner map for the two sets of co-ordinates entered.
This is a screenshot from one of my apps which does that using postcodes rather than coordinates, but the principle is the same.

 

[Minty]

That code @Gasman has posted worked really well for UK postcodes in an app I used about 8 years ago, kudos to @jdraw