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: 28 Mar 2024 at 6:15am
Software Version: Web Wiz Forums 12.03 - http://www.webwizforums.com


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" rel="nofollow - Roger Carlson thru this forum.)



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.03 - http://www.webwizforums.com
Copyright ©2001-2019 Web Wiz Ltd. - https://www.webwiz.net