Microsoft Access ZIP Code Lookup Template - SHORT VERSION - TechHelp (Post, Postal Code)

In this Microsoft Access tutorial, I'm going to show you how to perform a ZIP code lookup (post code or postal code in some countries). You will be able to enter a ZIP code and have the system return the city and state for that ZIP code (yes, works with most foreign countries too). If it doesn't exist in the database, you will be prompted to add it.

This video covers:
Create ZIP Code Lookup Table
After Update Event (AfterUpdate)
DLOOKUP Function
String Concatenation

Link to Download FREE Database Template: http://599CD.com/XXW8U

EXTENDED VERSION:

This is the SHORT version. In the EXTENDED VERSION of this tutorial, if the ZIP code exists but there is only ONE city in the database for that ZIP code, it will return it and populate your customer form. If the ZIP code exists but there are multiple cities, a form will appear allowing the user to select which city to use.

Get the EXTENDED VERSION here: http://599CD.com/XXW8U

OTHER LINKS:

FREE Customer Database Template: http://599cd.com/X47SS
After Update: https://youtu.be/KFMrSbmsrg4
DLOOKUP Function: https://youtu.be/ZmcGlywA4ss
Concatenation Tip: https://youtu.be/zzrd4tjPiYY
Concatenation TechHelp: https://youtu.be/V7ciQCuDSUk
SQL Basics: https://youtu.be/ULEmUobUWqc
Append Query: https://youtu.be/HALCvCUZsvs

RESOURCES:

Your Questions Answered: http://599cd.com/TechHelp
FREE Access Level 1: http://599cd.com/X113
$1 Access Level 2: http://599cd.com/X322
Learning Connection 50% OFF: http://599CD.com/XYTCNCT

Richard's Blog: http://599cd.com/blog
Access Forums: http://599cd.com/XAccessForum
Access Learning Zone Facebook Group: http://599CD.com/XZBTD
Twitter: https://twitter.com/LearningAccess

Email Me: [email protected]

https://en.wikipedia.org/wiki/Microsoft_Access
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft-365/blog/access/