If you like my Reference Database, please donate so I can keep on developing.
thank you
watch! 2015 Microsoft MVP Virtual Conference on Channel 9 (MSDN) for Access
53 minute presentation


Access Basics Video Tutorials Learn VBA ListFiles Database Random Picker Error Handling Reference Database Whistles & Bells Help Examples Crystal's Analyzer Code Documenter

thanks to Arvin Meyer for setting up this site and giving Access MVPs a place to share with others.

Download: (1.8 mb, Access 2000) (2 mb, Access 2013)  

Access database contains these tables:
  • Zip Codes — Zip, City, State, County, Latitude, Longitude -- US Zips (42K+ records)
  • Countries — Country Codes and Country Names (250 records)
  • States — State Abbreviations and State Names for the United States, Canada, and Military (72 records)
  • PhoAreaCodes — Telephone Area codes for the United States (380 records)
  • PhoIntlCodes — International Dialing codes for Phone calls (230 records)
  • Airlines — Airline Name and IATA codes for Airlines around the world, includes base Country and airline note (535 records) - updated Aug 6, 2009
  • Airports — Airport Name and IATA codes for Airports around the world, includes City and Country (and State for USA) (2,750 records) - updated Aug 6, 2009
  • Sample form — Example form showing 3 types of comboboxes to collect State. For more information, read the combobox example in Access Basics. (Nov 23, 2011)

Access 2013 version also has tables for Voltages, Flowers, ...


"Hi Crystal!! How do I set up a drop down box for state abbreviations in Access?

— Jodi

Thanks for your question, Jodi. I have added a sample form to the reference database showing how to set up 3 different types of comboboxes:
  1. combobox showing all states. Calculated textbox controls show Statename, Country code, IsActive flag
  2. combobox showing states with Active flag set. Calculated textbox controls show Statename, Country code.
  3. cascading combobox to pick Country and then State. Requery on AfterUpdate event of Ctry. Criteria in RowSource of State. Calculated control shows statename.
Example combobox

Free Book on Access: Access Basics

Free Tutorials: Video Tutorials

for information on private programming and training, or if you have comments and ideas, I'd love to hear from you

Copyright © 2009-2015 Crystal Long | All rights resorved | Last Updated November 2015 |