Print Page | Close Window

CityStateZip.mdb

Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: McAfee, David
Forum Description: David McAfee's Library
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=167
Printed Date: 17 Dec 2017 at 10:09pm


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: http://www.rogersaccesslibrary.com/forum/uploads/27/CityStateZip.zip - uploads/27/CityStateZip.zip



-------------
--

Email: (no longer valid. If you have any information, please contact http://www.rogersaccesslibrary.com/forum/member_profile.asp?PF=5 - Roger Carlson through this forum.)



Print Page | Close Window