|
code
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Data Type StringI have two words that I want to assing a data type (string) the two
words such as Pin Numbers, however, VB data type won't recognize unless the two words are joined as one word. And joining the two words is impossible since I am working with a pre existing database. Do you know how to work around this problem? <skenne***@gmail.com> wrote in message
news:1172764091.038283.326840@30g2000cwc.googlegroups.com... I have no idea what you're asking. Post some sample code that you tried > I have two words that I want to assing a data type (string) the two > words such as Pin Numbers, however, VB data type won't recognize > unless the two words are joined as one word. > > And joining the two words is impossible since I am working with a pre > existing database. > > Do you know how to work around this problem? which didn't work and maybe we can glean something from it. And I can't hold back: PIN stands for Personal Identifcation Number. "PIN Number" is "Personal Identification Number Number" and it's just stupid. "Jeff Johnson" <i.get@enough.spam> wrote in message It's common practice and makes perfect sense and there's nothing wrong withnews:uaqeuqBXHHA.4028@TK2MSFTNGP04.phx.gbl > And I can't hold back: PIN stands for Personal Identifcation Number. > "PIN Number" is "Personal Identification Number Number" and it's just > stupid. it. I'd rather see a PIN number than a PI number or have to use the AT machine. <gd&r> -- Reply to the group so all can participate VB.Net: "Fool me once..." "Bob Butler" <tiredofit@nospam.ever> wrote in message Run very fast.news:O2ZKy2BXHHA.3652@TK2MSFTNGP04.phx.gbl... >> And I can't hold back: PIN stands for Personal Identifcation Number. >> "PIN Number" is "Personal Identification Number Number" and it's just >> stupid. > > It's common practice and makes perfect sense and there's nothing wrong > with > it. I'd rather see a PIN number than a PI number or have to use the AT > machine. <gd&r> I read a quote recently that I like: "Ignorance does not equal language drift."
Show quote
Hide quote
"Jeff Johnson" <i.get@enough.spam> wrote in message nor does language drift equal ignorancenews:uZwPZ6BXHHA.1636@TK2MSFTNGP02.phx.gbl > "Bob Butler" <tiredofit@nospam.ever> wrote in message > news:O2ZKy2BXHHA.3652@TK2MSFTNGP04.phx.gbl... > >>> And I can't hold back: PIN stands for Personal Identifcation Number. >>> "PIN Number" is "Personal Identification Number Number" and it's >>> just stupid. >> >> It's common practice and makes perfect sense and there's nothing >> wrong with >> it. I'd rather see a PIN number than a PI number or have to use the >> AT machine. <gd&r> > > Run very fast. > > I read a quote recently that I like: "Ignorance does not equal > language drift." -- Reply to the group so all can participate VB.Net: "Fool me once..." "Bob Butler" <tiredofit@nospam.ever>'s wild thoughts were released on Thu, 1 Mar 2007 08:21:38 -0800 bearing thefollowing fruit: >"Jeff Johnson" <i.get@enough.spam> wrote in message It doesn't make sense at all, but it's misuse has become so>news:uaqeuqBXHHA.4028@TK2MSFTNGP04.phx.gbl >> And I can't hold back: PIN stands for Personal Identifcation Number. >> "PIN Number" is "Personal Identification Number Number" and it's just >> stupid. > >It's common practice and makes perfect sense and there's nothing wrong with >it. common that it may seem so. > I'd rather see a PIN number than a PI number or have to use the AT Would you really say ATM machine? I'd say 'I'm off to use>machine. <gd&r> the ATM' 'ATM machine' seems even odder then 'PIN number' to me. Another misused phrase that gets to me is 'It would be cheap at half the price' Well, yes it would, it would be half as much cheaper. What you really mean is 'cheap at twice the price' I swear the only thing that will keep me clinging to life as I get old will be the desire to moan about things like this ;-) "Jan Hyde" <StellaDrin***@REMOVE.ME.uboot.com> wrote in message "Hot water heater"news:sk0eu2lp1pk4p59qnir124hiuik1h2auil@4ax.com... > Another misused phrase that gets to me is > > 'It would be cheap at half the price' "I could care less" "I.e." used as "for example." Et cetera, et cetera, et cetera. "Jeff Johnson" <i.get@enough.spam>'s wild thoughts were released on Thu, 1 Mar 2007 11:54:51 -0500 bearing thefollowing fruit: >"Jan Hyde" <StellaDrin***@REMOVE.ME.uboot.com> wrote in message Used in the right context that could be funny.>news:sk0eu2lp1pk4p59qnir124hiuik1h2auil@4ax.com... > >> Another misused phrase that gets to me is >> >> 'It would be cheap at half the price' > >"Hot water heater" >"I could care less" J Show quoteHide quote >"I.e." used as "for example." > >Et cetera, et cetera, et cetera. > "Jeff Johnson" <i.get@enough.spam> wrote in message I'm thinking of getting a cold water cooler just to have the setnews:OCFMTJCXHHA.1000@TK2MSFTNGP05.phx.gbl > "Jan Hyde" <StellaDrin***@REMOVE.ME.uboot.com> wrote in message > news:sk0eu2lp1pk4p59qnir124hiuik1h2auil@4ax.com... > >> Another misused phrase that gets to me is >> >> 'It would be cheap at half the price' > > "Hot water heater" > "I could care less" Me too <g>> "I.e." used as "for example." Now that's just wrong!> Et cetera, et cetera, et cetera. We're ready for you now Mr Brynner-- Reply to the group so all can participate VB.Net: "Fool me once..."
Show quote
Hide quote
"Jan Hyde" <StellaDrin***@REMOVE.ME.uboot.com> wrote in message It makes sense to just about everybody else <g>news:sk0eu2lp1pk4p59qnir124hiuik1h2auil@4ax.com > "Bob Butler" <tiredofit@nospam.ever>'s wild thoughts were > released on Thu, 1 Mar 2007 08:21:38 -0800 bearing the > following fruit: > >> "Jeff Johnson" <i.get@enough.spam> wrote in message >> news:uaqeuqBXHHA.4028@TK2MSFTNGP04.phx.gbl >>> And I can't hold back: PIN stands for Personal Identifcation Number. >>> "PIN Number" is "Personal Identification Number Number" and it's >>> just stupid. >> >> It's common practice and makes perfect sense and there's nothing >> wrong with it. > > It doesn't make sense at all, but it's misuse has become so > common that it may seem so. >> I'd rather see a PIN number than a PI number or have to use the AT I'd say "there's an ATM machine in there I need to use" or maybe leave out>> machine. <gd&r> > > Would you really say ATM machine? I'd say 'I'm off to use > the ATM' "machine"... it wouldn't be a concious choice in that I wouldn't waste time thinking about it. > 'ATM machine' seems even odder then 'PIN number' to me. idioms are just that; "I could care less" is the prime example since taken> > Another misused phrase that gets to me is > > 'It would be cheap at half the price' > > Well, yes it would, it would be half as much cheaper. > What you really mean is 'cheap at twice the price' literally it has a different meaning. Computer languages are no place for things like this but human languages are different. If the meaning comes through then it's all good. > I swear the only thing that will keep me clinging to life as that's great because my goal is to be able to gripe about the moaners! <g>> I get old will be the desire to moan about things like this > ;-) -- Reply to the group so all can participate VB.Net: "Fool me once..." > idioms are just that; "I could care less" is the prime example since taken Actually, there's a much older example than that (albeit a word, not an > literally it has a different meaning. idiom): nice. There are very few people these days who would be insulted if you told them they were a nice person. That wasn't always the case. For those who aren't up on the etymology and historical usages of the word, see definitions 1 through 4 at http://www.m-w.com/dictionary/nice. Rob Robert Morley <rmor***@magma.ca.N0.Freak1n.sparn> wrote:
>> idioms are just that; "I could care less" is the prime example since taken Hence, "nice guys finish last..."? Yep, still fits.>> literally it has a different meaning. > > Actually, there's a much older example than that (albeit a word, not an > idiom): nice. There are very few people these days who would be insulted > if you told them they were a nice person. That wasn't always the case. For > those who aren't up on the etymology and historical usages of the word, see > definitions 1 through 4 at http://www.m-w.com/dictionary/nice. "Bob Butler" <tiredofit@nospam.ever>'s wild thoughts were released on Thu, 1 Mar 2007 09:03:44 -0800 bearing thefollowing fruit: Show quoteHide quote >"Jan Hyde" <StellaDrin***@REMOVE.ME.uboot.com> wrote in message I'm used to that ;-)>news:sk0eu2lp1pk4p59qnir124hiuik1h2auil@4ax.com >> "Bob Butler" <tiredofit@nospam.ever>'s wild thoughts were >> released on Thu, 1 Mar 2007 08:21:38 -0800 bearing the >> following fruit: >> >>> "Jeff Johnson" <i.get@enough.spam> wrote in message >>> news:uaqeuqBXHHA.4028@TK2MSFTNGP04.phx.gbl >>>> And I can't hold back: PIN stands for Personal Identifcation Number. >>>> "PIN Number" is "Personal Identification Number Number" and it's >>>> just stupid. >>> >>> It's common practice and makes perfect sense and there's nothing >>> wrong with it. >> >> It doesn't make sense at all, but it's misuse has become so >> common that it may seem so. > >It makes sense to just about everybody else <g> Show quoteHide quote > In this part of the country it's common to say >>> I'd rather see a PIN number than a PI number or have to use the AT >>> machine. <gd&r> >> >> Would you really say ATM machine? I'd say 'I'm off to use >> the ATM' > >I'd say "there's an ATM machine in there I need to use" or maybe leave out >"machine"... it wouldn't be a concious choice in that I wouldn't waste time >thinking about it. > >> 'ATM machine' seems even odder then 'PIN number' to me. >> >> Another misused phrase that gets to me is >> >> 'It would be cheap at half the price' >> >> Well, yes it would, it would be half as much cheaper. >> What you really mean is 'cheap at twice the price' > >idioms are just that; "I could care less" is the prime example since taken >literally it has a different meaning. Computer languages are no place for >things like this but human languages are different. If the meaning comes >through then it's all good. 'I can't meet with you while November' What they mean is 'I can't meet with you until December' It's recognised in the dictionary but I hate it. >> I swear the only thing that will keep me clinging to life as perfect ;-)>> I get old will be the desire to moan about things like this >> ;-) > >that's great because my goal is to be able to gripe about the moaners! <g> On Thu, 01 Mar 2007 16:48:31 +0000, Jan Hyde
<StellaDrin***@REMOVE.ME.uboot.com> wrote: in <sk0eu2lp1pk4p59qnir124hiuik1h2a***@4ax.com> Show quoteHide quote >"Bob Butler" <tiredofit@nospam.ever>'s wild thoughts were Or maybe - just maybe - the desire to moan just a wee little bit about>released on Thu, 1 Mar 2007 08:21:38 -0800 bearing the >following fruit: > >>"Jeff Johnson" <i.get@enough.spam> wrote in message >>news:uaqeuqBXHHA.4028@TK2MSFTNGP04.phx.gbl >>> And I can't hold back: PIN stands for Personal Identifcation Number. >>> "PIN Number" is "Personal Identification Number Number" and it's just >>> stupid. >> >>It's common practice and makes perfect sense and there's nothing wrong with >>it. > >It doesn't make sense at all, but it's misuse has become so >common that it may seem so. > >> I'd rather see a PIN number than a PI number or have to use the AT >>machine. <gd&r> > >Would you really say ATM machine? I'd say 'I'm off to use >the ATM' > >'ATM machine' seems even odder then 'PIN number' to me. > >Another misused phrase that gets to me is > >'It would be cheap at half the price' > >Well, yes it would, it would be half as much cheaper. >What you really mean is 'cheap at twice the price' > >I swear the only thing that will keep me clinging to life as >I get old will be the desire to moan about things like this >;-) > microsoft's misdeeds? C'mon man - give me a break. :-) And of course, the problem with PI Number is that everybody would think you
meant 3.14 (~ish <g>). So in that context, PIN Number does sorta make sense, even if it's a little redundant. But then again, humanity is rife with redundancies. Take, for example, international currency. One common format is: CAD$100.00 or USD$100.00. Now, why on earth do you need the "D", which stands for dollars, when you've got the dollar-sign right next to it? What about an LCD display? You actually DO need the display in there, after a fashion, to distinguish it from an LCD TV, though I've always preferred LCD monitor to refer to a computer screen. What is it about us English people that we always want to shorten things, anyway? The Internet has, of course, brought up all kinds of abbreviations, but what about even common things like Worcestershire sauce? I don't know very many people who actually pronounce all the syllables in that. But I digress.... I'll let you get back to the main point of "PIN Numbers". :) Rob Show quoteHide quote "Bob Butler" <tiredofit@nospam.ever> wrote in message news:O2ZKy2BXHHA.3652@TK2MSFTNGP04.phx.gbl... > "Jeff Johnson" <i.get@enough.spam> wrote in message > news:uaqeuqBXHHA.4028@TK2MSFTNGP04.phx.gbl >> And I can't hold back: PIN stands for Personal Identifcation Number. >> "PIN Number" is "Personal Identification Number Number" and it's just >> stupid. > > It's common practice and makes perfect sense and there's nothing wrong > with > it. I'd rather see a PIN number than a PI number or have to use the AT > machine. <gd&r> > > -- > Reply to the group so all can participate > VB.Net: "Fool me once..." > "Robert Morley" <rmor***@magma.ca.N0.Freak1n.sparn> wrote in message The one that sounds totally stupid to me is "cell phone". That's somethingnews:u4uZpgCXHHA.4880@TK2MSFTNGP05.phx.gbl > What is it about us English people that we always want to shorten > things, anyway? you might find in prison. Take the time to say "cellular" or use an alternative like "mobile". Your time is NOT that valuable that you have to save those 2 syllables. -- Reply to the group so all can participate VB.Net: "Fool me once..." I don't think they allow in-cell phones in most prisons, so it's probably
fairly safe to allow "cell phone", even if it is an abbreviation. I admit to being guilty as charged on that one, though. Rob Show quoteHide quote "Bob Butler" <tiredofit@nospam.ever> wrote in message news:uhfI1nCXHHA.4860@TK2MSFTNGP04.phx.gbl... > "Robert Morley" <rmor***@magma.ca.N0.Freak1n.sparn> wrote in message > news:u4uZpgCXHHA.4880@TK2MSFTNGP05.phx.gbl >> What is it about us English people that we always want to shorten >> things, anyway? > > The one that sounds totally stupid to me is "cell phone". That's > something > you might find in prison. Take the time to say "cellular" or use an > alternative like "mobile". Your time is NOT that valuable that you have > to > save those 2 syllables. > > -- > Reply to the group so all can participate > VB.Net: "Fool me once..." > > but what about even common things like Worcestershire sauce? The pronunciation I think you are thinking about appears to be a "real" word > I don't know very many people who actually pronounce all the > syllables in that. on its own... http://www.answers.com/topic/worcester-sauce Rick That's ONE of the pronunciations I've heard. I've also heard (using
pseudo-phonetic spelling, here) Worster sauce and Worstasher sauce, not to mention various fumblings of the name that often end with a pointed finger and "that stuff", and of course the vaguely amusing "what's this here sauce". Rob Show quoteHide quote "Rick Rothstein (MVP - VB)" <rickNOSPAMnews@NOSPAMcomcast.net> wrote in message news:eFdld4CXHHA.896@TK2MSFTNGP05.phx.gbl... >> but what about even common things like Worcestershire sauce? >> I don't know very many people who actually pronounce all the >> syllables in that. > > The pronunciation I think you are thinking about appears to be a "real" > word on its own... > > http://www.answers.com/topic/worcester-sauce > > Rick > On Thu, 1 Mar 2007 13:26:01 -0500, "Robert Morley"
<rmor***@magma.ca.N0.Freak1n.sparn> wrote: >That's ONE of the pronunciations I've heard. I've also heard (using It is Wooster sauce but the 'oo' is shorter than the 'oo' in Booster>pseudo-phonetic spelling, here) Worster sauce and Worstasher sauce, not to >mention various fumblings of the name that often end with a pointed finger >and "that stuff", and of course the vaguely amusing "what's this here >sauce". - closer to the way one pronounces 'u' in Push So "Wooster" like you'd say, "don't be a wuss"? :)
Well, it may be that in the UK, but then again, you guys are known for removing letters or entire syllables from the names of your towns, like Norwich (pr. Norrich), Birmingham (Birminham), Gloucestershire (Glostershire), Worcestershire (see previous discussion), and no doubt many others that us poor North Americans are unaware of. <grin> Rob Show quoteHide quote "J French" <erew***@nowhere.uk> wrote in message news:45e71d22.40509889@news.btopenworld.com... > On Thu, 1 Mar 2007 13:26:01 -0500, "Robert Morley" > <rmor***@magma.ca.N0.Freak1n.sparn> wrote: > >>That's ONE of the pronunciations I've heard. I've also heard (using >>pseudo-phonetic spelling, here) Worster sauce and Worstasher sauce, not to >>mention various fumblings of the name that often end with a pointed finger >>and "that stuff", and of course the vaguely amusing "what's this here >>sauce". > > It is Wooster sauce but the 'oo' is shorter than the 'oo' in Booster > > - closer to the way one pronounces 'u' in Push "Robert Morley" <rmor***@magma.ca.N0.Freak1n.sparn> wrote in message Live in New England for a while... Worcester, MA is also 'wooster' (and it'snews:eyH9LcDXHHA.4028@TK2MSFTNGP04.phx.gbl > So "Wooster" like you'd say, "don't be a wuss"? :) > > Well, it may be that in the UK, but then again, you guys are known for > removing letters or entire syllables from the names of your towns, > like Norwich (pr. Norrich), Birmingham (Birminham), Gloucestershire > (Glostershire), Worcestershire (see previous discussion), and no > doubt many others that us poor North Americans are unaware of. <grin> close to 'wuss' but more emphasis on the vowel rather than the 's') -- Reply to the group so all can participate VB.Net: "Fool me once..." >> So "Wooster" like you'd say, "don't be a wuss"? :) First time we went to visit my wife's sister just after she moved to >> >> Well, it may be that in the UK, but then again, you guys are known for >> removing letters or entire syllables from the names of your towns, >> like Norwich (pr. Norrich), Birmingham (Birminham), Gloucestershire >> (Glostershire), Worcestershire (see previous discussion), and no >> doubt many others that us poor North Americans are unaware of. <grin> > > Live in New England for a while... Worcester, MA is also 'wooster' (and > it's > close to 'wuss' but more emphasis on the vowel rather than the 's') Worcester... we completely missed the exit from the interstate highway to the town (must have driven 20 miles past the exit before we became suspicious)... she neglected to tell us that her town was pronounced "Wooster" but was spelled "Worcester"... we **knew** she didn't live in a town pronounced "war-kess-ter".<g> Rick On Thu, 1 Mar 2007 11:28:11 -0800, "Bob Butler" <tiredofit@nospam.ever> in <#G8QFfDXHHA.4***@TK2MSFTNGP04.phx.gbl> wrote: >Live in New England for a while... Worcester, MA is also 'wooster' (and it's I thought you were down the road a piece in south county.>close to 'wuss' but more emphasis on the vowel rather than the 's') "Stefan Berglund" <sorry.no.kool***@for.me> wrote in message I am, but this isn't the only place I've livednews:cl0fu2tcbf05ckq9ntndokiei5iijur08r@4ax.com > On Thu, 1 Mar 2007 11:28:11 -0800, "Bob Butler" > <tiredofit@nospam.ever> wrote: > in <#G8QFfDXHHA.4***@TK2MSFTNGP04.phx.gbl> > >> Live in New England for a while... Worcester, MA is also 'wooster' >> (and it's close to 'wuss' but more emphasis on the vowel rather than >> the 's') > > I thought you were down the road a piece in south county. -- Reply to the group so all can participate VB.Net: "Fool me once..." On Thu, 1 Mar 2007 14:22:37 -0500, "Robert Morley"
<rmor***@magma.ca.N0.Freak1n.sparn> wrote: >So "Wooster" like you'd say, "don't be a wuss"? :) Worcester MA. Big city...> >Well, it may be that in the UK, but then again, you guys are known for >removing letters or entire syllables from the names of your towns, like >Norwich (pr. Norrich), Birmingham (Birminham), Gloucestershire >(Glostershire), Worcestershire (see previous discussion), and no doubt many >others that us poor North Americans are unaware of. <grin> > > pronounced: Wooster So not just UK... <bg> Okay, now just to clarify: Worcester is pronounce Wooster, but what about
Worcestershire? Is it still Wooster...meaning you wonderful UK people are not only dropping the "rce", but also the entire last syllable "shire"? Rob Show quoteHide quote "PeterD" <pet***@hipson.net> wrote in message news:tkreu2du1l75t27k672m7kidfu7km1u8m6@4ax.com... > On Thu, 1 Mar 2007 14:22:37 -0500, "Robert Morley" > <rmor***@magma.ca.N0.Freak1n.sparn> wrote: > >>So "Wooster" like you'd say, "don't be a wuss"? :) >> >>Well, it may be that in the UK, but then again, you guys are known for >>removing letters or entire syllables from the names of your towns, like >>Norwich (pr. Norrich), Birmingham (Birminham), Gloucestershire >>(Glostershire), Worcestershire (see previous discussion), and no doubt >>many >>others that us poor North Americans are unaware of. <grin> >> >> > > Worcester MA. Big city... > > pronounced: Wooster > > So not just UK... <bg> On Thu, 1 Mar 2007 20:50:19 -0500, "Robert Morley"
<rmor***@magma.ca.N0.Freak1n.sparn> wrote: >Okay, now just to clarify: Worcester is pronounce Wooster, but what about It is Woostershire>Worcestershire? Is it still Wooster...meaning you wonderful UK people are >not only dropping the "rce", but also the entire last syllable "shire"? - although some people who live there might pronounce it as Warstershoirre They are of course wrong <g> Mind you, Americans have some funny pronounciations, my favourite is 'route' pronounced as 'rowt' rather than 'root' In British English a 'rout' is a total defeat and a 'router' is for gouging holes in things, not a message switching device. Reminds me, we've not been giving lessons in Brit slang recently ...
Show quote
Hide quote
"J French" <erew***@nowhere.uk> wrote in message In America (where the only correct English is still spoken) you always havenews:45e7d2f5.2684643@news.btopenworld.com... > On Thu, 1 Mar 2007 20:50:19 -0500, "Robert Morley" > <rmor***@magma.ca.N0.Freak1n.sparn> wrote: > > >Okay, now just to clarify: Worcester is pronounce Wooster, but what about > >Worcestershire? Is it still Wooster...meaning you wonderful UK people are > >not only dropping the "rce", but also the entire last syllable "shire"? > > It is Woostershire > > - although some people who live there might pronounce it as > Warstershoirre > > They are of course wrong <g> > > Mind you, Americans have some funny pronounciations, my favourite is > 'route' pronounced as 'rowt' rather than 'root' > > In British English a 'rout' is a total defeat and a 'router' is for > gouging holes in things, not a message switching device. > > Reminds me, we've not been giving lessons in Brit slang recently ... to consider context. For example, you will often hear people mix pronunciations, as in " To get to 'root' 66, take country 'rout' 40", or "I need to put the 'warsh' in the 'wahshing' machine". To insist that different things must be pronounced the same just because they unfortunately share the same arrangement of constants and vowels, smacks of franco-induced elitism. And thankfully is little tolerated by most Americans. -ralph <g> Now THAT's interesting. Here in Canada, everybody I know of pronounces the
message switching device as a "rowter", but "route" is "root"...and just to add to the confusion, some people pronounce the noun as "root", but the verb (i.e., to route something through somewhere) as "rowt". And on the topic of "roots", I remember being at Disneyworld in Florida a couple of years ago, and my friend and I were at the Canadian Pavilion, talking with the sales girl, who was from Canada as well (they try to "import" natives for each pavilion). Anyway, an American walks in and wants to know where the "Reuts" (aka "Roots") t-shirts are, which is a famous Canadian brand of clothing for those that don't know. I don't know if you've ever heard this particular accent--even here in Canada, which is a lot closer, I've only heard it a handful of times--but some Americans pronounce long "oo" sounds (like "root" or "roof") more like the "oo" in "foot" or "soot" (or the French "eu" sound, which is why I spelled it that way). So anyway, this guy comes in and asks for a "Reuts" t-shirt. The three of us all shared a look and tried REALLY hard to hide the smiles on our faces. I dunno if that translates well, but I guess it's kinda like the Brits feel when we talk about seeing a "soccer" game...it's just WRONG to hear it that way, yet somehow amusing at the same time. :D And finally, it's funny that you bring up British slang because just last night I found myself on a website that happens to include a British-American dictionary, including the various insult words, Cockney rhyming slang, and all kinds of other things. Very interesting for either the linguist, the hobbyist linguist like me, or the just plain curious. Here it is, for any who are interested: http://www.bbcamerica.com/content/141/dictionary.jsp. Rob Show quoteHide quote "J French" <erew***@nowhere.uk> wrote in message news:45e7d2f5.2684643@news.btopenworld.com... > On Thu, 1 Mar 2007 20:50:19 -0500, "Robert Morley" > <rmor***@magma.ca.N0.Freak1n.sparn> wrote: > >>Okay, now just to clarify: Worcester is pronounce Wooster, but what about >>Worcestershire? Is it still Wooster...meaning you wonderful UK people are >>not only dropping the "rce", but also the entire last syllable "shire"? > > It is Woostershire > > - although some people who live there might pronounce it as > Warstershoirre > > They are of course wrong <g> > > Mind you, Americans have some funny pronounciations, my favourite is > 'route' pronounced as 'rowt' rather than 'root' > > In British English a 'rout' is a total defeat and a 'router' is for > gouging holes in things, not a message switching device. > > Reminds me, we've not been giving lessons in Brit slang recently ... On Thu, 1 Mar 2007 12:36:28 -0500, "Robert Morley"
<rmor***@magma.ca.N0.Freak1n.sparn> wrote: >And of course, the problem with PI Number is that everybody would think you Actually it is the $ that is redundant>meant 3.14 (~ish <g>). So in that context, PIN Number does sorta make >sense, even if it's a little redundant. But then again, humanity is rife >with redundancies. Take, for example, international currency. One common >format is: CAD$100.00 or USD$100.00. Now, why on earth do you need the >"D", which stands for dollars, when you've got the dollar-sign right next to >it? I've done a lot of banking software and recognize CAD and USD as ISO codes, but until today I've never seen CAD$ or USD$ I've seen it with and without the $. I think the idea was to make it clear
that it was a monetary amount by including the symbol, but not being any form of financier, I won't claim that I know that for certain. Rob Show quoteHide quote "J French" <erew***@nowhere.uk> wrote in message news:45e71afb.39958394@news.btopenworld.com... > On Thu, 1 Mar 2007 12:36:28 -0500, "Robert Morley" > <rmor***@magma.ca.N0.Freak1n.sparn> wrote: > >>And of course, the problem with PI Number is that everybody would think >>you >>meant 3.14 (~ish <g>). So in that context, PIN Number does sorta make >>sense, even if it's a little redundant. But then again, humanity is rife >>with redundancies. Take, for example, international currency. One common >>format is: CAD$100.00 or USD$100.00. Now, why on earth do you need the >>"D", which stands for dollars, when you've got the dollar-sign right next >>to >>it? > > Actually it is the $ that is redundant > > I've done a lot of banking software and recognize CAD and USD as ISO > codes, but until today I've never seen CAD$ or USD$ > > On Thu, 1 Mar 2007 13:35:25 -0500, "Robert Morley"
<rmor***@magma.ca.N0.Freak1n.sparn> wrote: >I've seen it with and without the $. I think the idea was to make it clear Funny that, I'm familiar with $US and US$ but normally when you see>that it was a monetary amount by including the symbol, but not being any >form of financier, I won't claim that I know that for certain. USD or CAD you know that you are reading stuff written by someone with international banking experience. Well, I just saw CDN$ on a website last night, though that's not quite the
same, since there's no redundancy there. It could well be that people are mixing their symbols and ending up with redundancies as a result. I worked as a temp for several years, and in that time, I saw SOOO many different standards for things like phone numbers, international currency, dates, etc., it's not even funny. Rob Show quoteHide quote "J French" <erew***@nowhere.uk> wrote in message news:45e71f7b.41110614@news.btopenworld.com... > On Thu, 1 Mar 2007 13:35:25 -0500, "Robert Morley" > <rmor***@magma.ca.N0.Freak1n.sparn> wrote: > >>I've seen it with and without the $. I think the idea was to make it >>clear >>that it was a monetary amount by including the symbol, but not being any >>form of financier, I won't claim that I know that for certain. > > Funny that, I'm familiar with $US and US$ but normally when you see > USD or CAD you know that you are reading stuff written by someone with > international banking experience. erew***@nowhere.uk (J French)'s wild thoughts were released
on Thu, 01 Mar 2007 18:29:57 GMT bearing the following fruit: Show quoteHide quote >On Thu, 1 Mar 2007 12:36:28 -0500, "Robert Morley" Agreed - I've never seen both used.><rmor***@magma.ca.N0.Freak1n.sparn> wrote: > >>And of course, the problem with PI Number is that everybody would think you >>meant 3.14 (~ish <g>). So in that context, PIN Number does sorta make >>sense, even if it's a little redundant. But then again, humanity is rife >>with redundancies. Take, for example, international currency. One common >>format is: CAD$100.00 or USD$100.00. Now, why on earth do you need the >>"D", which stands for dollars, when you've got the dollar-sign right next to >>it? > >Actually it is the $ that is redundant > >I've done a lot of banking software and recognize CAD and USD as ISO >codes, but until today I've never seen CAD$ or USD$ On Fri, 02 Mar 2007 09:05:20 +0000, Jan Hyde
<StellaDrin***@REMOVE.ME.uboot.com> wrote: <snip> >>I've done a lot of banking software and recognize CAD and USD as ISO Have you also done banking stuff Jan ?>>codes, but until today I've never seen CAD$ or USD$ >Agreed - I've never seen both used. erew***@nowhere.uk (J French)'s wild thoughts were released
on Fri, 02 Mar 2007 09:32:36 GMT bearing the following fruit: >On Fri, 02 Mar 2007 09:05:20 +0000, Jan Hyde From a software pouint of view? Not really, part of our><StellaDrin***@REMOVE.ME.uboot.com> wrote: ><snip> > >>>I've done a lot of banking software and recognize CAD and USD as ISO >>>codes, but until today I've never seen CAD$ or USD$ > >>Agreed - I've never seen both used. > >Have you also done banking stuff Jan ? software suite is an accounts package (there can be a lot of bank accounts to mangage too) but it's not really my area, I don't think I'll ever get my head round accounts fully.
Show quote
Hide quote
"Jan Hyde" <StellaDrin***@REMOVE.ME.uboot.com> wrote in message Accounting software/programming is no problem once you appreciate that it isnews:3t7gu29chmciciohu727upl4vuqa1n40pt@4ax.com... > erew***@nowhere.uk (J French)'s wild thoughts were released > on Fri, 02 Mar 2007 09:32:36 GMT bearing the following > fruit: > > >On Fri, 02 Mar 2007 09:05:20 +0000, Jan Hyde > ><StellaDrin***@REMOVE.ME.uboot.com> wrote: > ><snip> > > > >>>I've done a lot of banking software and recognize CAD and USD as ISO > >>>codes, but until today I've never seen CAD$ or USD$ > > > >>Agreed - I've never seen both used. > > > >Have you also done banking stuff Jan ? > > From a software pouint of view? Not really, part of our > software suite is an accounts package (there can be a lot of > bank accounts to mangage too) but it's not really my area, I > don't think I'll ever get my head round accounts fully. > nothing more than a bunch of high-sounding re-naming and re-ordering of things you learned in the 5th Grade. One only needs to sit quietly and appear to take notes. It's only when one starts thinking there is something 'new' here and try to follow along, that one gets into trouble. -ralph <g>
Show quote
Hide quote
On Fri, 2 Mar 2007 07:33:56 -0600, "Ralph" <nt_consultin***@yahoo.com> Generally I've taken briefs from people, gone away and returned withwrote: > >"Jan Hyde" <StellaDrin***@REMOVE.ME.uboot.com> wrote in message >news:3t7gu29chmciciohu727upl4vuqa1n40pt@4ax.com... >> erew***@nowhere.uk (J French)'s wild thoughts were released >> on Fri, 02 Mar 2007 09:32:36 GMT bearing the following >> fruit: >> >> >On Fri, 02 Mar 2007 09:05:20 +0000, Jan Hyde >> ><StellaDrin***@REMOVE.ME.uboot.com> wrote: >> ><snip> >> > >> >>>I've done a lot of banking software and recognize CAD and USD as ISO >> >>>codes, but until today I've never seen CAD$ or USD$ >> > >> >>Agreed - I've never seen both used. >> > >> >Have you also done banking stuff Jan ? >> >> From a software pouint of view? Not really, part of our >> software suite is an accounts package (there can be a lot of >> bank accounts to mangage too) but it's not really my area, I >> don't think I'll ever get my head round accounts fully. >> >Accounting software/programming is no problem once you appreciate that it is >nothing more than a bunch of high-sounding re-naming and re-ordering of >things you learned in the 5th Grade. >One only needs to sit quietly and appear to take notes. It's only when one >starts thinking there is something 'new' here and try to follow along, that >one gets into trouble. something simple and intuitive. I suspect a lot of software is specified by accountants who are doing things by rote, and written by programmers who don't have a clue what they are doing. Taking a carving knife to it, and getting back down to the bare bones is quite interesting - although it can lead to punch ups with clients <g> Normally after the first battle, they learn ... and he hasn't even mentioned that the debits are near the window...
Show quoteHide quote "J French" <erew***@nowhere.uk> wrote in message news:45e92f89.2100722@news.btopenworld.com... > On Fri, 2 Mar 2007 07:33:56 -0600, "Ralph" <nt_consultin***@yahoo.com> > wrote: > >> >>"Jan Hyde" <StellaDrin***@REMOVE.ME.uboot.com> wrote in message >>news:3t7gu29chmciciohu727upl4vuqa1n40pt@4ax.com... >>> erew***@nowhere.uk (J French)'s wild thoughts were released >>> on Fri, 02 Mar 2007 09:32:36 GMT bearing the following >>> fruit: >>> >>> >On Fri, 02 Mar 2007 09:05:20 +0000, Jan Hyde >>> ><StellaDrin***@REMOVE.ME.uboot.com> wrote: >>> ><snip> >>> > >>> >>>I've done a lot of banking software and recognize CAD and USD as ISO >>> >>>codes, but until today I've never seen CAD$ or USD$ >>> > >>> >>Agreed - I've never seen both used. >>> > >>> >Have you also done banking stuff Jan ? >>> >>> From a software pouint of view? Not really, part of our >>> software suite is an accounts package (there can be a lot of >>> bank accounts to mangage too) but it's not really my area, I >>> don't think I'll ever get my head round accounts fully. >>> > >>Accounting software/programming is no problem once you appreciate that it >>is >>nothing more than a bunch of high-sounding re-naming and re-ordering of >>things you learned in the 5th Grade. > >>One only needs to sit quietly and appear to take notes. It's only when one >>starts thinking there is something 'new' here and try to follow along, >>that >>one gets into trouble. > > Generally I've taken briefs from people, gone away and returned with > something simple and intuitive. > > I suspect a lot of software is specified by accountants who are doing > things by rote, and written by programmers who don't have a clue what > they are doing. > > Taking a carving knife to it, and getting back down to the bare bones > is quite interesting - although it can lead to punch ups with clients > <g> > > Normally after the first battle, they learn ... "Jeff Johnson" <i.get@enough.spam>'s wild thoughts were released on Thu, 1 Mar 2007 11:00:08 -0500 bearing thefollowing fruit: Show quoteHide quote ><skenne***@gmail.com> wrote in message If you hadn't have done it I've been compeled to ;-)>news:1172764091.038283.326840@30g2000cwc.googlegroups.com... > >> I have two words that I want to assing a data type (string) the two >> words such as Pin Numbers, however, VB data type won't recognize >> unless the two words are joined as one word. >> >> And joining the two words is impossible since I am working with a pre >> existing database. >> >> Do you know how to work around this problem? > >I have no idea what you're asking. Post some sample code that you tried >which didn't work and maybe we can glean something from it. > >And I can't hold back: PIN stands for Personal Identifcation Number. "PIN >Number" is "Personal Identification Number Number" and it's just stupid. Jan Hyde <StellaDrin***@REMOVE.ME.uboot.com> wrote:
> "Jeff Johnson" <i.get@enough.spam>'s wild thoughts were Alright then, how's this usage read: "Today, the NASA launched...">> And I can't hold back: PIN stands for Personal Identifcation Number. "PIN >> Number" is "Personal Identification Number Number" and it's just stupid. > > If you hadn't have done it I've been compeled to ;-) That sounds dumb. It's perfectly grammatically correct, of course,
but...eww! Rob Show quoteHide quote "Karl E. Peterson" <k***@mvps.org> wrote in message news:OLPYo7CXHHA.4860@TK2MSFTNGP04.phx.gbl... > Jan Hyde <StellaDrin***@REMOVE.ME.uboot.com> wrote: >> "Jeff Johnson" <i.get@enough.spam>'s wild thoughts were >>> And I can't hold back: PIN stands for Personal Identifcation Number. >>> "PIN >>> Number" is "Personal Identification Number Number" and it's just stupid. >> >> If you hadn't have done it I've been compeled to ;-) > > Alright then, how's this usage read: "Today, the NASA launched..." > -- > .NET: It's About Trust! > http://vfred.mvps.org > "Karl E. Peterson" <k***@mvps.org> wrote in message AAAAGGGGHHHHH!!!!news:OLPYo7CXHHA.4860@TK2MSFTNGP04.phx.gbl... > Alright Karl E. Peterson <k***@mvps.org> wrote:
> Jan Hyde <StellaDrin***@REMOVE.ME.uboot.com> wrote: Beats "the google", eh? <gd&r>>> "Jeff Johnson" <i.get@enough.spam>'s wild thoughts were >>> And I can't hold back: PIN stands for Personal Identifcation Number. "PIN >>> Number" is "Personal Identification Number Number" and it's just stupid. >> >> If you hadn't have done it I've been compeled to ;-) > > Alright then, how's this usage read: "Today, the NASA launched..." "Karl E. Peterson" <k***@mvps.org> wrote in message I just heard someone say that yesterday and almost screamed.news:OUEnhNDXHHA.1000@TK2MSFTNGP05.phx.gbl... > Beats "the google", eh? <gd&r> Jeff Johnson <i.get@enough.spam> wrote:
> "Karl E. Peterson" <k***@mvps.org> wrote in message Ever googled "the google"? <g>> news:OUEnhNDXHHA.1000@TK2MSFTNGP05.phx.gbl... > >> Beats "the google", eh? <gd&r> > > I just heard someone say that yesterday and almost screamed. "Karl E. Peterson" wrote...
: Ever googled "the google"? <g> Goggle at google, and google yahoo.-- Jim Carlock Post replies to the group.
Show quote
Hide quote
"Jeff Johnson" <i.get@enough.spam> skrev i meddelandet What if it is kind of a hardware IC database with Pin Numbers from say 1 tonews:uaqeuqBXHHA.4028@TK2MSFTNGP04.phx.gbl... > <skenne***@gmail.com> wrote in message > news:1172764091.038283.326840@30g2000cwc.googlegroups.com... > > > I have two words that I want to assing a data type (string) the two > > words such as Pin Numbers, however, VB data type won't recognize > > unless the two words are joined as one word. > > > > And joining the two words is impossible since I am working with a pre > > existing database. > > > > Do you know how to work around this problem? > > I have no idea what you're asking. Post some sample code that you tried > which didn't work and maybe we can glean something from it. > > And I can't hold back: PIN stands for Personal Identifcation Number. "PIN > Number" is "Personal Identification Number Number" and it's just stupid. > > 64? Is that stupid? /Henning "Henning" <computer_h***@coldmail.com> wrote in message No, but you're silly.news:45e7f942$0$17843$57c3e1d3@news3.bahnhof.se... > What if it is kind of a hardware IC database with Pin Numbers from say 1 > to > 64? Is that stupid? "Jeff Johnson" <i.get@enough.spam> skrev i meddelandet Ahaa! The fact that you know of no other Pin Numbers than PIN, makes menews:uMGT8UQXHHA.4668@TK2MSFTNGP04.phx.gbl... > "Henning" <computer_h***@coldmail.com> wrote in message > news:45e7f942$0$17843$57c3e1d3@news3.bahnhof.se... > > > What if it is kind of a hardware IC database with Pin Numbers from say 1 > > to > > 64? Is that stupid? > > No, but you're silly. > > stupid? /Henning "Jeff Johnson" <i.get@enough.spam> skrev i meddelandet Ahaaa! The fact that you know of no other Pin Numbers than PIN, makes menews:uMGT8UQXHHA.4668@TK2MSFTNGP04.phx.gbl... > "Henning" <computer_h***@coldmail.com> wrote in message > news:45e7f942$0$17843$57c3e1d3@news3.bahnhof.se... > > > What if it is kind of a hardware IC database with Pin Numbers from say 1 > > to > > 64? Is that stupid? > > No, but you're silly. > > silly? /Henning "Henning" <computer_h***@coldmail.com> wrote in message No, the fact that you're deliberately being silly makes you silly*. And a news:45e890fa$0$17842$57c3e1d3@news3.bahnhof.se... >> > What if it is kind of a hardware IC database with Pin Numbers from say >> > 1 >> > to >> > 64? Is that stupid? >> >> No, but you're silly. >> >> > Ahaaa! The fact that you know of no other Pin Numbers than PIN, makes me > silly? "Pin Number" is NOT the same as a "PIN Number." As much as I hate case-sensitivity in a programming language, it definitely applies in written language! *In fact, some may consider this a pun. (In which case you should be shot....)
Show quote
Hide quote
"Jeff Johnson" <i.get@enough.spam> skrev i meddelandet And the OP did write "Pin Numbers", you put in the "PIN Number".news:OmEWASRXHHA.2052@TK2MSFTNGP04.phx.gbl... > "Henning" <computer_h***@coldmail.com> wrote in message > news:45e890fa$0$17842$57c3e1d3@news3.bahnhof.se... > > >> > What if it is kind of a hardware IC database with Pin Numbers from say > >> > 1 > >> > to > >> > 64? Is that stupid? > >> > >> No, but you're silly. > >> > >> > > Ahaaa! The fact that you know of no other Pin Numbers than PIN, makes me > > silly? > > No, the fact that you're deliberately being silly makes you silly*. And a > "Pin Number" is NOT the same as a "PIN Number." As much as I hate > case-sensitivity in a programming language, it definitely applies in written > language! > > And your writing is not offending?> *In fact, some may consider this a pun. (In which case you should be > shot....) > > This will lead to nothing, so I'm out of the arguing. Even if I still can't get what is upsetting _you_. /Henning
Show quote
Hide quote
"Henning" <computer_h***@coldmail.com> wrote in message Ohhhhh, I see. You've actually been completely serious this whole time? Wow.news:45e8ac85$0$17843$57c3e1d3@news3.bahnhof.se... >> >> > What if it is kind of a hardware IC database with Pin Numbers from > say >> >> > 1 >> >> > to >> >> > 64? Is that stupid? >> >> >> >> No, but you're silly. >> >> >> >> >> > Ahaaa! The fact that you know of no other Pin Numbers than PIN, makes >> > me >> > silly? >> >> No, the fact that you're deliberately being silly makes you silly*. And a >> "Pin Number" is NOT the same as a "PIN Number." As much as I hate >> case-sensitivity in a programming language, it definitely applies in > written >> language! >> > And the OP did write "Pin Numbers", you put in the "PIN Number". >> >> *In fact, some may consider this a pun. (In which case you should be >> shot....) >> >> > And your writing is not offending? > This will lead to nothing, so I'm out of the arguing. Even if I still > can't > get what is upsetting _you_. Okay, here's the deal: Yes, you are correct, the original poster wrote "Pin Number." I made the assumption (or as I like to think of it, "played the odds") and figured the poster was talking about Personal Identification Numbers--as such a thing is far more common in databases than the pin numbers you're talking about--and went on my rant. Many people can't be bothered to hold down the Shift key long enough to capitalize an acronym or they simply don't know that PIN actually IS an acronym (which is likely, because then they'd probably understand the redundancy of "PIN number"). I thought you were being tounge-in-cheek with your literal interpretation of the question. I guess you weren't.
Show quote
Hide quote
"Jeff Johnson" <i.get@enough.spam> skrev i meddelandet Ok, taken! Yes I was, and thats why I couldn't understand.news:e5mnB82XHHA.992@TK2MSFTNGP04.phx.gbl... > "Henning" <computer_h***@coldmail.com> wrote in message > news:45e8ac85$0$17843$57c3e1d3@news3.bahnhof.se... > > >> >> > What if it is kind of a hardware IC database with Pin Numbers from > > say > >> >> > 1 > >> >> > to > >> >> > 64? Is that stupid? > >> >> > >> >> No, but you're silly. > >> >> > >> >> > >> > Ahaaa! The fact that you know of no other Pin Numbers than PIN, makes > >> > me > >> > silly? > >> > >> No, the fact that you're deliberately being silly makes you silly*. And a > >> "Pin Number" is NOT the same as a "PIN Number." As much as I hate > >> case-sensitivity in a programming language, it definitely applies in > > written > >> language! > >> > > And the OP did write "Pin Numbers", you put in the "PIN Number". > >> > >> *In fact, some may consider this a pun. (In which case you should be > >> shot....) > >> > >> > > And your writing is not offending? > > This will lead to nothing, so I'm out of the arguing. Even if I still > > can't > > get what is upsetting _you_. > > Ohhhhh, I see. You've actually been completely serious this whole time? Wow. > > Okay, here's the deal: Yes, you are correct, the original poster wrote "Pin > Number." I made the assumption (or as I like to think of it, "played the > odds") and figured the poster was talking about Personal Identification > Numbers--as such a thing is far more common in databases than the pin > numbers you're talking about--and went on my rant. Many people can't be > bothered to hold down the Shift key long enough to capitalize an acronym or > they simply don't know that PIN actually IS an acronym (which is likely, > because then they'd probably understand the redundancy of "PIN number"). > > I thought you were being tounge-in-cheek with your literal interpretation of > the question. I guess you weren't. > > You knew I couldn't leave did you. I agree that PIN Number is equal to IC circuit. Friends? /Henning "Henning" <computer_h***@coldmail.com> wrote in message There you go!! Or NIC card....news:45eca13e$0$17842$57c3e1d3@news3.bahnhof.se... > Ok, taken! Yes I was, and thats why I couldn't understand. > You knew I couldn't leave did you. I agree that PIN Number is equal to IC > circuit. > Friends? Absolutely, once "IC circuit" sank in. (The line break threw me for a moment!) "Henning" stated...
: Ok, taken! Yes I was, and thats why I couldn't understand. "Jeff Johnson" posted...: You knew I couldn't leave did you. I agree that PIN Number : is equal to IC circuit. : There you go!! Or NIC card.... NIC card? You lost me there. I thought serial port and parallelport. Isn't "NIC card" like Network Interface Card card? ;-) -- Jim Carlock Post replies to the group.
Show quote
Hide quote
On Mon, 5 Mar 2007 22:42:54 -0500, "Jim Carlock" <anonymous@localhost> Or LCD Display :-}wrote: >"Henning" stated... >: Ok, taken! Yes I was, and thats why I couldn't understand. >: You knew I couldn't leave did you. I agree that PIN Number >: is equal to IC circuit. > >"Jeff Johnson" posted... >: There you go!! Or NIC card.... > >NIC card? You lost me there. I thought serial port and parallel >port. >Isn't "NIC card" like Network Interface Card card? ;-) "J French" wrote
: Or LCD Display :-} Or Microsoft defined "multiple protocol adapters"???http://msdn.microsoft.com/library/en-us/mswnsk98/html/vbmthBindMethod.asp -- Jim Carlock Post replies to the group.
Show quote
Hide quote
"Jim Carlock" <anonymous@localhost> wrote in message Uh, yeah. Did you miss the earlier stuff about Personal Identification news:eRXKJG6XHHA.992@TK2MSFTNGP02.phx.gbl... > "Henning" stated... > : Ok, taken! Yes I was, and thats why I couldn't understand. > : You knew I couldn't leave did you. I agree that PIN Number > : is equal to IC circuit. > > "Jeff Johnson" posted... > : There you go!! Or NIC card.... > > NIC card? You lost me there. I thought serial port and parallel > port. > > Isn't "NIC card" like Network Interface Card card? ;-) Number number and Integrated Circuit circuit? > "Henning" stated... "Jim Carlock" replied...> : Ok, taken! Yes I was, and thats why I couldn't understand. > : You knew I couldn't leave did you. I agree that PIN Number > : is equal to IC circuit. > > "Jeff Johnson" posted... > : There you go!! Or NIC card.... > NIC card? You lost me there. I thought serial port and parallel "Jeff Johnson" posted...> port. > > Isn't "NIC card" like Network Interface Card card? ;-) : Uh, yeah. Did you miss the earlier stuff about Personal Yeah, realized I read all that after posting. The left side reached: Identification Number number and Integrated Circuit circuit? over into the right side and created an unendless loop as the right side artistically bungled the logic the left side tried to comprehend. -- Jim Carlock Post replies to the group. Jeff Johnson wrote:
> *In fact, some may consider this a pun. (In which case you should be Come the revolution, we shall line them up against the wall, in Pun Number order.> shot....) > "Bob O`Bob" <filter***@yahoogroups.com> wrote in message Assuming we can first determine which one has the dimple or dot so we wouldnews:eKr1XiXXHHA.4308@TK2MSFTNGP05.phx.gbl... > Jeff Johnson wrote: > > > *In fact, some may consider this a pun. (In which case you should be > > shot....) > > > > > Come the revolution, we shall line them up against the wall, in Pun Number order. know where to start counting. -ralph Ralph wrote:
Show quoteHide quote > "Bob O`Bob" <filter***@yahoogroups.com> wrote in message "face down, nine-edge first"> news:eKr1XiXXHHA.4308@TK2MSFTNGP05.phx.gbl... >> Jeff Johnson wrote: >> >>> *In fact, some may consider this a pun. (In which case you should be >>> shot....) >>> >> >> Come the revolution, we shall line them up against the wall, in Pun Number > order. > > Assuming we can first determine which one has the dimple or dot so we would > know where to start counting. > <skenne***@gmail.com> wrote in message
news:1172764091.038283.326840@30g2000cwc.googlegroups.com I think you need to post a sample of what you are trying to do. Column> I have two words that I want to assing a data type (string) the two > words such as Pin Numbers, however, VB data type won't recognize > unless the two words are joined as one word. > > And joining the two words is impossible since I am working with a pre > existing database. > > Do you know how to work around this problem? names in a database can include spaces (it's a bad idea IMO but it happens) while VB variables can not but the two are not the same so it doesn't matter dim sPIN As String set rs=db.execute("Select [PIN Number] from thetable where whatever") sPIN= "" & rs.Fields("PIN Number").Value Msgbox sPIN, vbOKOnly,"PIN Number" sPIN="42" db.execute "Update thetable Set [PIN Number]='" & sPIN & "' where whatever" -- Reply to the group so all can participate VB.Net: "Fool me once..."
Show quote
Hide quote
On Mar 1, 11:00 am, "Bob Butler" <tiredo...@nospam.ever> wrote: Thank you Jeff and Bob for the help.> <skenne***@gmail.com> wrote in message > > news:1172764091.038283.326840@30g2000cwc.googlegroups.com > > > I have two words that I want to assing a data type (string) the two > > words such as Pin Numbers, however, VB data type won't recognize > > unless the two words are joined as one word. > > > And joining the two words is impossible since I am working with a pre > > existing database. > > > Do you know how to work around this problem? > > I think you need to post a sample of what you are trying to do. Column > names in a database can include spaces (it's a bad idea IMO but it happens) > while VB variables can not but the two are not the same so it doesn't matter > > dim sPIN As String > set rs=db.execute("Select [PIN Number] from thetable where whatever") > sPIN= "" & rs.Fields("PIN Number").Value > Msgbox sPIN, vbOKOnly,"PIN Number" > sPIN="42" > db.execute "Update thetable Set [PIN Number]='" & sPIN & "' where whatever" > > -- > Reply to the group so all can participate > VB.Net: "Fool me once..." Here's what I was trying to accomplish: --------------------------------------------------------------------- Private Sub cmdSearch_Click() Dim Pin NumberRef As String Dim strSearch As String 'Check txtSearch for Null value or Nill Entry first. If IsNull(Me![txtSearch]) Or (Me![txtSearch]) = "" Then MsgBox "Please enter a value!", vbOKOnly, "Invalid Search Criterion!" Me![txtSearch].SetFocus Exit Sub End If DoCmd.ShowAllRecords DoCmd.GoToControl ("Pin Number") DoCmd.FindRecord Me!txtSearch Pin Number.SetFocus Pin NumberRef = Pin Number txtSearch.SetFocus strSearch = txtSearch End If End Sub <skenne***@gmail.com> wrote in message
news:1172766329.627699.130930@n33g2000cwc.googlegroups.com VB can't have a NULL in a textbox; not sure about VBA in Access which is> Thank you Jeff and Bob for the help. > > Here's what I was trying to accomplish: > --------------------------------------------------------------------- > Private Sub cmdSearch_Click() > Dim Pin NumberRef As String > Dim strSearch As String > > 'Check txtSearch for Null value or Nill Entry first. what your code appears to be. For future reference you should ask in an Access VBA newsgroup since while VB and VBA overlap they are not the same thing. > If IsNull(Me![txtSearch]) Or (Me![txtSearch]) = "" Then Again, not sure about Access VBA but in VB the "preferred" test would beIf Len(txtSearch.Text)=0 Then > MsgBox "Please enter a value!", vbOKOnly, "Invalid Search While I'm at it, yelling at your users is bad form.> Criterion!" http://homepage.mac.com/bradster/iarchitect/ > Me![txtSearch].SetFocus If you have a control named "Pin Number" then that's a huge difference from> Exit Sub > End If > > DoCmd.ShowAllRecords > DoCmd.GoToControl ("Pin Number") > DoCmd.FindRecord Me!txtSearch > > Pin Number.SetFocus > Pin NumberRef = Pin Number VB -- that would not be allowed. My guess would be that you'd have to stick with the ugly Me! syntax Me![Pin Number].SetFocus and lose the space in "Pin NumberRef" but re-posting in an Access VBA newsgroup would be the best option since people responding there would be more familiar with it. > txtSearch.SetFocus > strSearch = txtSearch > > End If > End Sub -- Reply to the group so all can participate VB.Net: "Fool me once..."
Show quote
Hide quote
On Mar 1, 11:39 am, "Bob Butler" <tiredo...@nospam.ever> wrote: --------------------------------------------> <skenne***@gmail.com> wrote in message > > news:1172766329.627699.130930@n33g2000cwc.googlegroups.com > > > Thank you Jeff and Bob for the help. > > > Here's what I was trying to accomplish: > > --------------------------------------------------------------------- > > Private Sub cmdSearch_Click() > > Dim Pin NumberRef As String > > Dim strSearch As String > > > 'Check txtSearch for Null value or Nill Entry first. > > VB can't have a NULL in a textbox; not sure about VBA in Access which is > what your code appears to be. For future reference you should ask in an > Access VBA newsgroup since while VB and VBA overlap they are not the same > thing. > > > If IsNull(Me![txtSearch]) Or (Me![txtSearch]) = "" Then > > Again, not sure about Access VBA but in VB the "preferred" test would be > If Len(txtSearch.Text)=0 Then > > > MsgBox "Please enter a value!", vbOKOnly, "Invalid Search > > Criterion!" > > While I'm at it, yelling at your users is bad form.http://homepage.mac.com/bradster/iarchitect/ > > > Me![txtSearch].SetFocus > > Exit Sub > > End If > > > DoCmd.ShowAllRecords > > DoCmd.GoToControl ("Pin Number") > > DoCmd.FindRecord Me!txtSearch > > > Pin Number.SetFocus > > Pin NumberRef = Pin Number > > If you have a control named "Pin Number" then that's a huge difference from > VB -- that would not be allowed. My guess would be that you'd have to stick > with the ugly Me! syntax > Me![Pin Number].SetFocus > > and lose the space in "Pin NumberRef" > > but re-posting in an Access VBA newsgroup would be the best option since > people responding there would be more familiar with it. > > > txtSearch.SetFocus > > strSearch = txtSearch > > > End If > > End Sub > > -- > Reply to the group so all can participate > VB.Net: "Fool me once..." Thank you Bob, I will post in Access VB group. <skenne***@gmail.com> wrote in message
news:1172767783.849774.158960@t69g2000cwt.googlegroups.com... I recommend microsoft.public.access.formscoding.> Thank you Bob, I will post in Access VB group. > Again, not sure about Access VBA but in VB the "preferred" test would be In Access, a control's .Text property can't be accessed unless the control > If Len(txtSearch.Text)=0 Then has the focus (which is very annoying). The .Value property doesn't suffer that affliction. The way I commonly use to deal with Nulls and empty strings is: If Nz(Me!txtSearch.Value)="" Then... Nz is an Access function which converts a Null to an Empty (i.e., "" or 0, depending on data type). > My guess would be that you'd have to stick To my knowledge, Me! is the preferred format in Access...at least > with the ugly Me! syntax > Me![Pin Number].SetFocus personally, I would never even consider using implicit control names without prefacing them with Me! (not to be confused with prefacing them with me <g>). And yes, you're right, the square brackets are necessary for names with spaces in them. Rob Woops, I should've said that Nz is a function which returns Empty if a Null
is passed, but will otherwise return the value passed unchanged. That makes a bit more sense, doesn't it? <blush> Rob Show quoteHide quote "Robert Morley" <rmor***@magma.ca.N0.Freak1n.sparn> wrote in message news:%23fqIdxCXHHA.4252@TK2MSFTNGP06.phx.gbl... >> Again, not sure about Access VBA but in VB the "preferred" test would be >> If Len(txtSearch.Text)=0 Then > > In Access, a control's .Text property can't be accessed unless the control > has the focus (which is very annoying). The .Value property doesn't > suffer that affliction. The way I commonly use to deal with Nulls and > empty strings is: If Nz(Me!txtSearch.Value)="" Then... Nz is an Access > function which converts a Null to an Empty (i.e., "" or 0, depending on > data type). > >> My guess would be that you'd have to stick >> with the ugly Me! syntax >> Me![Pin Number].SetFocus > > To my knowledge, Me! is the preferred format in Access...at least > personally, I would never even consider using implicit control names > without prefacing them with Me! (not to be confused with prefacing them > with me <g>). And yes, you're right, the square brackets are necessary > for names with spaces in them. > > > > Rob > "Robert Morley" <rmor***@magma.ca.N0.Freak1n.sparn> wrote in message Not in VB it doesn't. Nz() returns an empty STRING. "Empty" means something news:%23n$s$3CXHHA.1764@TK2MSFTNGP04.phx.gbl... > Woops, I should've said that Nz is a function which returns Empty if a > Null is passed, but will otherwise return the value passed unchanged. > That makes a bit more sense, doesn't it? <blush> else.... In VB6, the Nz() function doesn't exist at all. In Access, it returns the
original value if a value was passed, or Empty (which then gets converted to either "" or 0, depending on the data type receiving it). Debug.Print TypeName(Nz(Null)) returns "Empty" in Access. The VB6 equivalent would be some variation of: Public Function Nz(ByVal Value As Variant, Optional ByVal ValueIfNull As Variant) As Variant If IsNull(Value) Then If IsMissing(ValueIfNull) Then ValueIfNull = Empty Nz = ValueIfNull Else Nz = Value End If End Function Then, lngNumber = Nz(Null) returns 0, and strString = Nz(Null) returns "", due to the implicit conversion of Empty to whatever is appropriate for the underlying data type. Rob Show quoteHide quote "Jeff Johnson" <i.get@enough.spam> wrote in message news:ueG%23wEDXHHA.3980@TK2MSFTNGP02.phx.gbl... > "Robert Morley" <rmor***@magma.ca.N0.Freak1n.sparn> wrote in message > news:%23n$s$3CXHHA.1764@TK2MSFTNGP04.phx.gbl... > >> Woops, I should've said that Nz is a function which returns Empty if a >> Null is passed, but will otherwise return the value passed unchanged. >> That makes a bit more sense, doesn't it? <blush> > > Not in VB it doesn't. Nz() returns an empty STRING. "Empty" means > something else.... > "Robert Morley" <rmor***@magma.ca.N0.Freak1n.sparn> wrote in message That's very interesting. I was going on what the documentation says, and it news:e7zl%23NDXHHA.4240@TK2MSFTNGP06.phx.gbl... > Debug.Print TypeName(Nz(Null)) returns "Empty" in Access. never mentions Empty once. ? IsEmpty(Nz(Null)) returns True. And ? Empty = "" returns True as well, in both Access and VB. ETC at work....  
Other interesting topics
Problems after installing Visual Basic 6 on XP Professional SP2
VB6 App Deployment in Vista OT - MS: $4,000 for Daylight Saving Fix Within a *.exe Looking for a way to call LogOff and Shutdown. Source Control via Network Drive Cannot quit Excel called from VB6 Sin, Cos Autologon on Vista DoCmd.SendObject |
|||||||||||||||||||||||
