N
News
Anyone know a good place on the web to find drop down lists I can use for my
lookup fields?
Ethnity
States
Countries, etc
Thank you !
lookup fields?
Ethnity
States
Countries, etc
Thank you !
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
TC
Uh, drop down lists *of what*?
I'm quite keen on scuba diving. I could undoubtledly give you drop down
lists of famous dive sites, scuba equipment manufacturers, dive shops
around the world, scuba certifying agencies, steel & aluminium air tank
sizes, and so on. Would those help? :-?
Seriously, no-one knows what you're actually asking. Are "ethnicity",
"states" and "countries" meant as examples of something more general?
If so - what? What do you want some drop down lists *of*?
HTH,
TC (MVP Access)
http://tc2.atspace.com
I'm quite keen on scuba diving. I could undoubtledly give you drop down
lists of famous dive sites, scuba equipment manufacturers, dive shops
around the world, scuba certifying agencies, steel & aluminium air tank
sizes, and so on. Would those help? :-?
Seriously, no-one knows what you're actually asking. Are "ethnicity",
"states" and "countries" meant as examples of something more general?
If so - what? What do you want some drop down lists *of*?
HTH,
TC (MVP Access)
http://tc2.atspace.com
N
News
LoL
Not the cub Diving, not yet anyway.
List of Countries
List of 50 States
other commonly used in various forms.
Just wanted to know if there was a site on the net someone could refer me to
that has this type of data.
Vincent
Not the cub Diving, not yet anyway.
List of Countries
List of 50 States
other commonly used in various forms.
Just wanted to know if there was a site on the net someone could refer me to
that has this type of data.
Vincent
T
TC
You say "this type of data".
*WHAT* type of data?
I still don't understand what data you're looking for.
Country flags?
National foods?
State religions?
You'll have to be clearer. At present we don't know what you are trying
to find.
TC (MVP Access)
http://tc2.atspace.com
*WHAT* type of data?
I still don't understand what data you're looking for.
Country flags?
National foods?
State religions?
You'll have to be clearer. At present we don't know what you are trying
to find.
TC (MVP Access)
http://tc2.atspace.com
N
News
States - NY, NJ, MD, VA, etc
Countruies - United Kingdom, United States, United Arab Emirates, Nigeria,
etc
A simple "go away, we are too advanced to help a novice" would have
sufficed, instead of sarcasm.
Countruies - United Kingdom, United States, United Arab Emirates, Nigeria,
etc
A simple "go away, we are too advanced to help a novice" would have
sufficed, instead of sarcasm.
J
John Nurick
When I want lists like that I find them myself. Have you heard of search
engines? Use search terms that describe and are included in the types of
list you're looking for, e.g.
list countries states abbreviations
and pay more attention to lists from official sources such as the UPU
and ISO.
I wonder whether you have considered searching the web using terms
engines? Use search terms that describe and are included in the types of
list you're looking for, e.g.
list countries states abbreviations
and pay more attention to lists from official sources such as the UPU
and ISO.
I wonder whether you have considered searching the web using terms
T
TC
There was nothing in my second post that a reasonable person could take
offence at IMHO.
Let's cut to the chase. You've asked a hopelessly imprecise question.
No-one can possibly answer it, until you explain it more clearly. I've
been trying to tell you this in a light-hearted fashion, instead of
having to speak bluntly, as I am doing now.
That is not *refusing* to help a novice - it is *attempting to do so*.
Sorry that you can not see that.
TC (MVP Access)
http://tc2.atspace.com
offence at IMHO.
Let's cut to the chase. You've asked a hopelessly imprecise question.
No-one can possibly answer it, until you explain it more clearly. I've
been trying to tell you this in a light-hearted fashion, instead of
having to speak bluntly, as I am doing now.
That is not *refusing* to help a novice - it is *attempting to do so*.
Sorry that you can not see that.
TC (MVP Access)
http://tc2.atspace.com
N
News
I have been looking and I have found some good stuff.
I was just inquiring if the "pro's" knew of a site that was dedicated to
suck lists.
Chancer are, someone over the past 20 years created such lists that are
commonly used, adn somehwere along the line, these were centralized in one
location. Or atleast provided links to such resources.
Sory to waiste vluable time.
Would someone be able to point me to more of a beginner newsgroup, I dont
want to waiste the time of such talented MVP's with my novice questions,
besides, I can only handle so much abuse and sarcasm. *Have you ever heard
of Search Engines* - in other words, "this guy is obviously not an MVP, lets
run him through loops, and never answer his question.
I was just inquiring if the "pro's" knew of a site that was dedicated to
suck lists.
Chancer are, someone over the past 20 years created such lists that are
commonly used, adn somehwere along the line, these were centralized in one
location. Or atleast provided links to such resources.
Sory to waiste vluable time.
Would someone be able to point me to more of a beginner newsgroup, I dont
want to waiste the time of such talented MVP's with my novice questions,
besides, I can only handle so much abuse and sarcasm. *Have you ever heard
of Search Engines* - in other words, "this guy is obviously not an MVP, lets
run him through loops, and never answer his question.
T
TC
Geez, this is absolutely, positively, the last response that I will
give to you:
WHAT DO YOU MEAN BY THE TERM, >>> " S U C H L I S T S " <<<
?
DO YOU NOT FRIGGIN' UNDERSTAND, WE DO NOT UNDERSTAND ***
W_H_A_T K_I_N_D O_F F_R_I_G_G_I_N ' L_I_S_T_S Y_O_U
W_A_N_T *** ? ? ?
Pal, do not try to insult the good folks here, who spend hours of their
own personal time, at no charge to anyone, trying to help people JUST
LIKE YOU.
Unfortunately, some people are U_N_H_E_L_P_A_B_L_E.
You are one of those.
Good(PERMANENTLY)bye,
TC
give to you:
WHAT DO YOU MEAN BY THE TERM, >>> " S U C H L I S T S " <<<
?
DO YOU NOT FRIGGIN' UNDERSTAND, WE DO NOT UNDERSTAND ***
W_H_A_T K_I_N_D O_F F_R_I_G_G_I_N ' L_I_S_T_S Y_O_U
W_A_N_T *** ? ? ?
Pal, do not try to insult the good folks here, who spend hours of their
own personal time, at no charge to anyone, trying to help people JUST
LIKE YOU.
Unfortunately, some people are U_N_H_E_L_P_A_B_L_E.
You are one of those.
Good(PERMANENTLY)bye,
TC
N
News
Ididnt insult anyone until I was insulted
Positively
G-O-F-U-C-K-Y-O-U-R-S-E-L-F
Positively
G-O-F-U-C-K-Y-O-U-R-S-E-L-F
N
News
perhaps I should elaborate
I am currently in an enviornment with limited bandwidth and internet
connectivity.
a simple Google search on "the wizard of oz" might take 10 minutes to load,
if it does. I am currently communicating on this newsgroup via sat link
from an area approx 100 km from Baghdad. If I had some bandwidth and some
time, I would most likely not even post.
I was tasked to design a form, without any guidance on how, but this form is
to be emailed to many senior officers in the navy and marine corps. the
form contains questions regarding manpower an strategy in the current war we
are fighting. I am a novice to access, and just wanted to know of any sites
or of any guidance regarding building lookup fields SUCH AS a list of
Countries (not the colognes or birds, or the products) but the Countries
themselves. For instance, like the one I am currently in, Iraq, and the one
you're in the United States....comfortable, I might to ridicule someone like
myself for not being a professional "let me sit here and **** with a guy
asking a simple question".
Its people like you who make most real Americans sickyour replies saying
"you're the best", they do that because they want to be nice. But inside,
they hate your arrogance and cockiness.
You're simply a bunch of geeks who were never welcome in society; and unlike
folks like Bill Gates and Steve Jobs, you never even had an original
thought or vision. Only allot of time and resources to learn and master
what most people don't have time for cause they are too busy living life,
not designing tables and standing on soapboxes.
Thanks again, you make me proud to serve. Glad my sacrifices allowed you to
continue being an asshole, even just for a little while.
(Permanent) Goodbye
Dont worry, Ill most likely die in this war anyway, imsure that will make
you real happy, dick.
I am currently in an enviornment with limited bandwidth and internet
connectivity.
a simple Google search on "the wizard of oz" might take 10 minutes to load,
if it does. I am currently communicating on this newsgroup via sat link
from an area approx 100 km from Baghdad. If I had some bandwidth and some
time, I would most likely not even post.
I was tasked to design a form, without any guidance on how, but this form is
to be emailed to many senior officers in the navy and marine corps. the
form contains questions regarding manpower an strategy in the current war we
are fighting. I am a novice to access, and just wanted to know of any sites
or of any guidance regarding building lookup fields SUCH AS a list of
Countries (not the colognes or birds, or the products) but the Countries
themselves. For instance, like the one I am currently in, Iraq, and the one
you're in the United States....comfortable, I might to ridicule someone like
myself for not being a professional "let me sit here and **** with a guy
asking a simple question".
Its people like you who make most real Americans sickyour replies saying
"you're the best", they do that because they want to be nice. But inside,
they hate your arrogance and cockiness.
You're simply a bunch of geeks who were never welcome in society; and unlike
folks like Bill Gates and Steve Jobs, you never even had an original
thought or vision. Only allot of time and resources to learn and master
what most people don't have time for cause they are too busy living life,
not designing tables and standing on soapboxes.
Thanks again, you make me proud to serve. Glad my sacrifices allowed you to
continue being an asshole, even just for a little while.
(Permanent) Goodbye
Dont worry, Ill most likely die in this war anyway, imsure that will make
you real happy, dick.
T
TC
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
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
T
TC
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-services/iso3166ma/02iso-3166-code-lists/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
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-services/iso3166ma/02iso-3166-code-lists/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
A
accessquestions
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)
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)
T
TC
Ok, that's a good source also.
Good luck with your form!
Cheers,
TC (MVP Access)
http://tc2.atspace.com
(off for 2 days)
Good luck with your form!
Cheers,
TC (MVP Access)
http://tc2.atspace.com
(off for 2 days)
D
Douglas J. Steele
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
(no private e-mails, please)
Enjoy yourself.
http://www.cia.gov/cia/publications/factbook/index.html
--
Doug Steele, Microsoft Access MVP
(no private e-mails, please)
TC said: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.
A
accessquestions
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.
advancd for me) , but still a good place to learn about access.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.