Show number of customers per zip code on a map (1 Viewer)

[jmark@stayintouch.us]

Is it possible in Access to create a Form or Report that will show a map (like Google Maps) that shows our 4 Retail Store Locations and then all the Zip Codes around the store and the number of Customers that have addresses in each Zip Code? This may be too complicated for Access? thanks!

 

[theDBguy]

Just thinking out loud, but I don't see why not by using REST API through Google or Bing Maps. Have you looked into that?

 

[June7]

cross-post https://www.utteraccess.com/topics/2065267/posts/2817332

 

[jmark@stayintouch.us]

I have not yet,. but thanks for the idea. I have lots of experience with VBA and Access in general, but none with APIs. Do you have any resources you could point me to? thansk!

 

[theDBguy]

I have not yet,. but thanks for the idea. I have lots of experience with VBA and Access in general, but none with APIs. Do you have any resources you could point me to? thansk!

There have been some discussions here with regards to using REST APIs. Try to do a quick search. I'll see if I can find a link for you too.

 

[mike60smart]

I have not yet,. but thanks for the idea. I have lots of experience with VBA and Access in general, but none with APIs. Do you have any resources you could point me to? thansk!

Colin Riddington (Mendip Data Systems), Access MVP 2022-2023, Website is probably your best point of contact as he has
covered this extensively.

 

[Gasman]

cross-post https://www.utteraccess.com/topics/2065267/posts/2817332

Seems to be a habit.

 

[isladogs]

This should be easy to do as long as you know the geo-coordinates of each zip code.
You would then add a marker layer at each zip code position with the number of customers
The only problem is that each marker can only have a single character so you may need to show a table with the number alongside the map.

See my article

Annotate Google Maps

The first article in a series which demonstrates ways of 'annotating' downloaded maps to personalise these for your clients. Features include the use of marker points, lines, circles & boundary shapes, nearby places and styles. All features are added as new map layers. An example app is provided.

isladogs.co.uk

 

[moke123]

If your in the U.S., check the U.S.P.S. website. They have a bunch of API's.

Web Tools APIs | USPS

USPS Web Tools APIs let ecommerce website and shipping software developers access USPS data and features free of charge. Check shipping rates, verify addresses, track packages, schedule package pickups, and more through USPS Web Tools.

www.usps.com

Google Maps Platform | Google for Developers

Google Maps Platform descriptions

developers.google.com