Geting travel distance from a map - add-in
in [Forms]
|
Prev: Detail in form goes blank
Next: Detecting a Character
From: CAM on 7 Mar 2010 14:43 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
From: Gina Whipp on 7 Mar 2010 22:28 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 "CAM" <alex_martinez(a)ca.rrXXX.com> wrote in message news:4F7D022F-FCB1-49FE-85B5-ADC513FD2270(a)microsoft.com... 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
From: Mike Painter on 7 Mar 2010 22:43 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 wrote: > 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
From: CAM on 8 Mar 2010 09:19 Gina, thanks for your help I believe I found a solution. I appreciate your help. Thank you again. "Gina Whipp" <NotInterested(a)InViruses.com> wrote in message news:uwHxy9mvKHA.3408(a)TK2MSFTNGP06.phx.gbl... > 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 > > "CAM" <alex_martinez(a)ca.rrXXX.com> wrote in message > news:4F7D022F-FCB1-49FE-85B5-ADC513FD2270(a)microsoft.com... > 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 >
From: CAM on 8 Mar 2010 09:20
Mike Thanks for your help, I will check it out. I appreicate your time. Thanks again. Regards "Mike Painter" <md.painter(a)sbcglobal.net> wrote in message news:Nn_kn.4538$jt1.1797(a)newsfe01.iad... > 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 wrote: >> 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 > > |