[AccessD] Distance between zip codes

Rocky Smolin rockysmolin at bchacc.com
Tue May 23 08:35:50 CDT 2017


I've found a couple of zip/lat/long free downloads and fond some code that
calculates the distance.  So I think I may be covered. To take one zip code
and calculate the distance to all the others takes about 15 seconds on my i7
box with SSD.  

R


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

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

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



More information about the AccessD mailing list