[AccessD] Distance between zip codes

[Jim Dettman]

Rocky,

 I'm not aware of any tool, other than using a web browser control and one
of the mapping services (Google, Bing, or Mapquest)

 The problem with all the mapping services is that at some point, you need
to start paying to use it.  They only allow so many free calls a day.

 But I do have code to do this more or less.   What I do is given a list of
lat/long's, a point, and a number of miles, figure out who in that list is
in the radius.

 In my case it is the location of people, but it could easily be zips.  All
you'd need is a list of the lat/long for each.

Jim.

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Rocky Smolin
Sent: Tuesday, May 23, 2017 07:37 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Distance between zip codes

Dear List:

 

I have a client who wants to know all of the zip codes that lie within a
certain radius of a selected zip code.

 

I seem to recall some discussion about this on the list but it could have
been 15 years ago now. 

 

Is there some tool available that can be dropped into and Access FE (using
2010 now).

 

MTIA

 

 

Rocky Smolin

Beach Access Software

760-683-5777

 <http://www.bchacc.com> www.bchacc.com

 <http://www.e-z-mrp.com> www.e-z-mrp.com

Skype: rocky.smolin

 

 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com