Calculating driving distance at 45 mph between two stops.

[mbenton]

Hi, I'm creating a form that has a command button that I want to calculate driving distance (at 45mph) between stops. The form will be based on a table called Supplierstbl which holds supplier addresses including zip codes. I think I'll need to have Access get the distance from Google. Can anyone offer suggestions on how to do this or point me to some good examples that I can observe the coding? The user should only need to select the two zipcodes from the supplier table and push the command (calculate dist.) button. Thanks.

[alansidman]

Look at this link and see if it does what you need

http://www.access-programmers.co.uk/...d.php?t=225339

I believe that this was developed by our moderator Orange. If you like this, be sure to thank him with some rep points.

[mbenton]

This works great!! Very simple to use and quick. I will need to figure out how/where to base the time going 45 mph as I'm sure this is probably based on a much faster speed. Do you have any suggestions on where/how I can change the speed?