UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> State Abbreviations    
 
   
RexRivers
post Sep 9 2010, 04:48 PM
Post #1

UtterAccess Addict
Posts: 164
From: Hamilton, NJ USA



Any suggestions on State abbreviations?
Text Box or Combo Box?
If Combo, should I just type in the values as the row source in the table or actually create a table with abbreviations in it.

I figure a text box opens up a greater possibility of user error.
Go to the top of the page
 
+
niesz
post Sep 9 2010, 05:06 PM
Post #2

Utter A-fishin'-ado
Posts: 17,957
From: Cincinnati, Ohio, USA . . . ><((((°>



The best method would be to create a States table that holds the abbreviation and full state name. You never know when you'll need the full name.

You can use a combo box to select them.


--------------------
Walter Niesz | Microsoft Access MVP 2007-12 | Link Library | Function Library | UtterAccess Wiki TOC
"By iron, iron itself is sharpened. So one man sharpens the face of another."
Go to the top of the page
 
+
strive4peace
post Sep 9 2010, 05:37 PM
Post #3

UtterAccess Leader
Posts: 20,329



Hi Rex,

here is a database that has a States table you can import instead of creating it yourself:

Reference Database
compiled by Crystal
http://www.accessmvp.com/Strive4Peace/Reference

Access 2000 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

~~~

hi Walter < any good fishing lately?
Go to the top of the page
 
+
RexRivers
post Sep 10 2010, 10:03 AM
Post #4

UtterAccess Addict
Posts: 164
From: Hamilton, NJ USA



Awesome Crystal. Thank you!
Go to the top of the page
 
+
strive4peace
post Sep 10 2010, 10:17 AM
Post #5

UtterAccess Leader
Posts: 20,329



you're welcome, Rex < happy to help
Go to the top of the page
 
+

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Search  ·  Go to Top  ·  Lo-Fi Version Time is now: 25th July 2014 - 08:03 PM