Geting travel distance from a map - add-in

[CAM]

Hello,

I have a user who goes into the Internet using Bing map or Google map to get
sales person driving miles from point A to point B. My user inputs in
separate fileds the From/To Address, City, State, Zip Code. The mileages is
all calculated in a report. We are using Access 2003. The problem is there
are many salespersons and each individual sales person travels to many
different places. This is very time comsuming to go in the Internet and get
the mileage. What I like to is have the user input into various fields in a
table the FROM - The address, City, State, Zip and the TO - Address, City,
State, Zip Code and get the actual mileage distance, which appears in
report. I'm wandering if there any add-in or a way to do this so the user
don't need to go into the Bing or Google Map to get the travel distance.
Any help, tips will be appreciated. Thank you in advance.

Regards

 

[Gina Whipp]

Cam,

I have a module for this that I use for a very similiar purpose but it is
based on longitude/latitude not zip code (and will not work with zip codes).
I had to purchase a zip code database to get longitude and latitude.
Perhaps because it is salespeople the company has already purchased such a
database? I'll await your reply...

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Hello,

I have a user who goes into the Internet using Bing map or Google map to get
sales person driving miles from point A to point B. My user inputs in
separate fileds the From/To Address, City, State, Zip Code. The mileages is
all calculated in a report. We are using Access 2003. The problem is there
are many salespersons and each individual sales person travels to many
different places. This is very time comsuming to go in the Internet and get
the mileage. What I like to is have the user input into various fields in a
table the FROM - The address, City, State, Zip and the TO - Address, City,
State, Zip Code and get the actual mileage distance, which appears in
report. I'm wandering if there any add-in or a way to do this so the user
don't need to go into the Bing or Google Map to get the travel distance.
Any help, tips will be appreciated. Thank you in advance.

Regards

 

[Mike Painter]

To get actual road mileage is a non trivial problem.
I'd check with Google and see if they have anything that you might use.

http://www.klynas.com/streets.html also has a pretty good program.
"Also featured is a router that can automatically create delivery groups,
optimize a travel agenda, and give written travel directions (with
distance, time, fuel usage, etc.). For example you can import 1000
addresses, automatically divide them into local groups by distance,
optimize the visiting order, and generate travel directions. There is also
a GPS interface to track your vehicle (or fleet of moving vehicles), and a
programmer's interface to add mapping features to other applications."

I think,MSFT's mapquest does a similar job .

This is also a case where a device called a pencil, used in conjunction with
paper migh be teh best way to go.
Buy them all a GPS system and have them write down the mileage when they get
directions.

 

[CAM]

Gina, thanks for your help I believe I found a solution. I appreciate your
help. Thank you again.

 

[CAM]

Mike Thanks for your help, I will check it out. I appreicate your time.
Thanks again.
Regards

 

[Gina Whipp]

CAM,

Glad you found something that will work. If you get a chance perhaps you
could post it so others might benefit... It's bound to assist someone else
in your situation.


Gina, thanks for your help I believe I found a solution. I appreciate your
help. Thank you again.