Prev: Detail in form goes blank
Next: Detecting a Character
From: Gina Whipp on 8 Mar 2010 11:19
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.

"CAM" <alex_martinez(a)ca.rr.com> wrote in message
news:1ED34B3F-68F9-43B8-AF03-C2AD6AA82877(a)microsoft.com...

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
>

First  |  Prev  | 
Pages: 1 2
Prev: Detail in form goes blank
Next: Detecting a Character