UtterAccess.com
We have detected that you are using an unsupported web browser. We recommend you to upgrade your web browser to get the most from UtterAccess forums.
Why should and how can I upgrade?
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.
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.
Go to the top of the page
 
+
strive4peace
post Sep 9 2010, 05:37 PM
Post #3

UtterAccess Leader
Posts: 20,385



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
~~~
OWalter < 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,385



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 October 2014 - 08:21 AM

Tag cloud: