Print Page | Close Window


Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: McAfee, David
Forum Description: David McAfee's Library
Printed Date: 21 Mar 2019 at 9:32am

Topic: CityStateZip.mdb
Posted By: David McAfee
Subject: CityStateZip.mdb
Date Posted: 10 Jul 2008 at 4:06am
In addition to providing a list of cities by zip codes, this sample also shows how to 
handle the three DAO returned recordset possibilities:

1. Nothing returned (0 records)
2. One record returned
3. More than one record returned.

If nothing is returned, a pop up form is called which allows the user to add a new 
zipcode & city. If one is returned, the data is automatically filled in. If more than one 
is returned, the user is prompted to choose the correct value (city). 

Download Access 97: - uploads/27/


Email: (no longer valid. If you have any information, please contact - Roger Carlson through this forum.)

Print Page | Close Window