Results 1 to 7 of 7
  1. #1
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    1,324

    API to find City,State given a zip code


    There seems to be a variety of approaches listed online about obtaining the name of the city and state given a zip code, most seem to focus on interfaces for web designers. Does anyone have a simple API based function they're willing to share?

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    14,708
    Bill,

    I'm not sure what you're looking for exactly. If you google "free online zip to city state", you'll get a number of hits.
    USPS , Melissa and zip-codes seem to satisfy the need, but each would require you to interface with their web site.

    This site says it has a free zipcode database for download, but it appears to have been set up in 2012 ( I have not used it so can not comment further).
    Good luck.

  3. #3
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    1,324
    Looking for VBA function I can run from code given a zip code and wanting the corresponding city.

  4. #4
    isladogs's Avatar
    isladogs is offline Very idle programmer
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    4,069
    See if this link helps http://allenbrowne.com/ser-65.html. The links provided may not be up to date
    Colin (Mendip Data Systems) : Website, email
    If this has helped, please click the star button and leave a comment

  5. #5
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    1,324
    Allen's USA list is a bit out-of-date and a whole lot more than what's needed and would add more than 4MB to the size of the app. I could table a subset of what Allen has for a couple of western states and save the rest in an external auxiliary file if a zip code comes out of the blue I've not got tabled. That would be rare but manageable.

    I'd rather have a clean function I can pass a zip code in a call from VBA.

  6. #6
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    14,708

  7. #7
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    1,324
    Yes, that's better............. but still

Please reply to this thread with any new information or opinions.

Similar Threads

  1. drop down selections (country/state/city)
    By fastforded in forum Access
    Replies: 11
    Last Post: 03-26-2015, 07:40 AM
  2. Replies: 2
    Last Post: 03-18-2014, 10:15 AM
  3. Texas City,State,Zip and Area Code
    By burrina in forum Sample Databases
    Replies: 0
    Last Post: 11-12-2012, 10:35 PM
  4. Normalizing various City/County/State combinations (w/out zip)
    By DorkyDuvessa in forum Database Design
    Replies: 2
    Last Post: 05-08-2011, 07:49 PM
  5. City, State Zip lookup
    By garywmcp in forum Access
    Replies: 1
    Last Post: 04-24-2011, 06:15 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums