A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Drop Down Lists



 
 
Thread Tools Display Modes
  #11  
Old April 8th, 2006, 02:48 AM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default Drop Down Lists

Here's what I suggest. Reword your original question to make it as
clear as you possibly can. Then post it back here, and I will do my
level best to help you. That new exchange of posts, will constitute our
joint apology to each-other for how this thread has gone so far.

The ball is in your court.

TC (MVP Access)
http://tc2.atspace.com

  #12  
Old April 8th, 2006, 05:11 PM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default Drop Down Lists

Hi Vincent

The main authority for country codes, is the International Standards
Organization or ISO. The official list of those codes is given in
document ISO 3166-1, which at present contains 240 country names and
corresponding letter codes. You can view that list on the web at
http://www.iso.org/iso/en/prods-serv.../list-en1.html

Alternatively, I've downloaded all those names and codes, and saved
them into an Access database in Access 2000 format, and also in a "flat
text" file in tab delimited format. You can download either or both of
those two files at http://tc2.atspace.com/vincent.htm

Hope this helps,
TC (MVP Access)
http://tc2.atspace.com

  #13  
Old April 9th, 2006, 08:49 AM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default Drop Down Lists

Awesome
Thank TC.
I found that the US postal service is also a good place for easy lists for
drop down, I found States, Territories, ZIP codes, and allot more....(Just
in case anyone else out there is looking)

"TC" wrote in message
ups.com...
Hi Vincent

The main authority for country codes, is the International Standards
Organization or ISO. The official list of those codes is given in
document ISO 3166-1, which at present contains 240 country names and
corresponding letter codes. You can view that list on the web at
http://www.iso.org/iso/en/prods-serv.../list-en1.html

Alternatively, I've downloaded all those names and codes, and saved
them into an Access database in Access 2000 format, and also in a "flat
text" file in tab delimited format. You can download either or both of
those two files at http://tc2.atspace.com/vincent.htm

Hope this helps,
TC (MVP Access)
http://tc2.atspace.com



  #14  
Old April 9th, 2006, 11:44 AM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default Drop Down Lists

Ok, that's a good source also.

Good luck with your form!

Cheers,
TC (MVP Access)
http://tc2.atspace.com
(off for 2 days)

  #15  
Old April 9th, 2006, 12:21 PM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default Drop Down Lists

Another site you might want to keep in your "bag of tricks" is
http://www.cia.gov/cia/publications/factbook/index.html

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"TC" wrote in message
oups.com...
Ok, that's a good source also.

Good luck with your form!

Cheers,
TC (MVP Access)
http://tc2.atspace.com
(off for 2 days)


Enjoy yourself.


  #16  
Old April 9th, 2006, 04:57 PM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default Drop Down Lists

Nice, thanks (I like your web page BTW) got some good stuff (although too
advancd for me) , but still a good place to learn about access.


"Douglas J. Steele" wrote in message
...
Another site you might want to keep in your "bag of tricks" is
http://www.cia.gov/cia/publications/factbook/index.html

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"TC" wrote in message
oups.com...
Ok, that's a good source also.

Good luck with your form!

Cheers,
TC (MVP Access)
http://tc2.atspace.com
(off for 2 days)


Enjoy yourself.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I have hierarchial drop down lists in Excel Kunal Worksheet Functions 2 March 20th, 2006 03:08 PM
time sheet drop down lists Steve General Discussion 12 March 18th, 2006 10:30 PM
drop down lists johnny.exe New Users 2 March 3rd, 2006 06:35 PM
Drop Down Lists Saxman New Users 5 November 11th, 2005 11:52 PM
linking drop down menu items to corresponding items in other lists Jklay General Discussion 2 June 15th, 2004 07:42 PM


All times are GMT +1. The time now is 12:40 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.