Dawn Crosier, Thanks i got a lot infomation from this site
Thanks Brij here. ----- Original Message ----- From: "Crosier, Dawn" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Tuesday, November 29, 2005 11:31 PM Subject: RE: [AccessDevelopers] SPECIAL CHARACTER > Try this website: http://www.lookuptables.com/ > > Dawn Crosier > Application Specialist > "Education Lasts a Lifetime" > > This message was posted to a newsgroup. Please post replies and > questions to the group so that others can learn as well. > > > ________________________________ > > From: [email protected] > [mailto:[EMAIL PROTECTED] On Behalf Of brij > Sent: Monday, November 28, 2005 9:42 PM > To: [email protected] > Subject: Re: [AccessDevelopers] SPECIAL CHARACTER > > > hi friend, > > i am glad to have reply from your side. > thanks. > > but i want to know about all the Special charater. > do u have list of all special charater. > i wonna make one function of this special charater and > replace them by appropreate setting. > > so do u have list of all special charater which create error in > insert query. > > yes u r right chr(34) works but some other charater also create errors. > and > i wonna use this all charater in insert query only. > > Thanks for your help. > thanks dear. > > Brij here. > > ----- Original Message ----- > From: Lonnie Johnson <mailto:[EMAIL PROTECTED]> > To: [email protected] > Sent: Monday, November 28, 2005 5:50 PM > Subject: Re: [AccessDevelopers] SPECIAL CHARACTER > > > You could also try using Chr(34) > > If you give us your SQL statement I can show you how to use it. > > Anil Kumar <[EMAIL PROTECTED]> wrote: > > hi, > > 1. Double Quotes > if u're using double quotes in a string, u've to use > this special character 2 times(immediately) to appear as a character. > > eg. ur o/p : I am a proud "INDIAN" > to get the above o/p, u should give the string like > msgbox "I'm a proud ""INDIAN"" " > > 2. Single QUotes > > if u're using single quotes inside a string, there's no > problem occurs. but if u're using single quotes outside a string, from > that character Access VBA will take it as a comment. > > hope that ur problem solved. > > > brij <[EMAIL PROTECTED]> wrote: > > Hello to all friends > > here i want to know some thing about > special character > like ' ". > when i try to insert this character i got error > what would i do to avoid this type of errors ? > > what this character are called ? > > brij here > > > SPONSORED LINKS > Microsoft access developer > <http://groups.yahoo.com/gads?t=ms&k=Microsoft+access+developer&w1=Micro > soft+access+developer&w2=Microsoft+access+help&w3=Microsoft+access+datab > ase&w4=Microsoft+access+training&w5=Microsoft+access+training+course&w6= > Microsoft+access+programming&c=6&s=193&.sig=d-CjBIrYOH9NCKHYFeGZJA> > Microsoft access help > <http://groups.yahoo.com/gads?t=ms&k=Microsoft+access+help&w1=Microsoft+ > access+developer&w2=Microsoft+access+help&w3=Microsoft+access+database&w > 4=Microsoft+access+training&w5=Microsoft+access+training+course&w6=Micro > soft+access+programming&c=6&s=193&.sig=crx-d4AAhdklv_VozGVAUw> > Microsoft access database > <http://groups.yahoo.com/gads?t=ms&k=Microsoft+access+database&w1=Micros > oft+access+developer&w2=Microsoft+access+help&w3=Microsoft+access+databa > se&w4=Microsoft+access+training&w5=Microsoft+access+training+course&w6=M > icrosoft+access+programming&c=6&s=193&.sig=qg2hDuQNweByMCX0NU7cEA> > Microsoft access training > <http://groups.yahoo.com/gads?t=ms&k=Microsoft+access+training&w1=Micros > oft+access+developer&w2=Microsoft+access+help&w3=Microsoft+access+databa > se&w4=Microsoft+access+training&w5=Microsoft+access+training+course&w6=M > icrosoft+access+programming&c=6&s=193&.sig=bLZHqTqWUQny609X1OkmNA> > Microsoft access training course > <http://groups.yahoo.com/gads?t=ms&k=Microsoft+access+training+course&w1 > =Microsoft+access+developer&w2=Microsoft+access+help&w3=Microsoft+access > +database&w4=Microsoft+access+training&w5=Microsoft+access+training+cour > se&w6=Microsoft+access+programming&c=6&s=193&.sig=d8GQXfQW3RZ64rOfzIMo8A >> Microsoft access programming > <http://groups.yahoo.com/gads?t=ms&k=Microsoft+access+programming&w1=Mic > rosoft+access+developer&w2=Microsoft+access+help&w3=Microsoft+access+dat > abase&w4=Microsoft+access+training&w5=Microsoft+access+training+course&w > 6=Microsoft+access+programming&c=6&s=193&.sig=iXDlL79-kkgjv6fLyFu3Sg> > > > ________________________________ > > Yahoo! Music Unlimited - Access over 1 million songs. > Try it free. > <http://pa.yahoo.com/*http://us.rd.yahoo.com/evt=36035/*http://music.yah > oo.com/unlimited/> > > > > > May God bless you beyond your imagination! > Lonnie Johnson > ProDev, Professional Development of MS Access Databases > Visit me at ==> http://www.prodev.us <http://www.prodev.us/> > > > > > <http://www.galaxymall.com/software/PRODEV> > > > ________________________________ > > Yahoo! Music Unlimited - Access over 1 million songs. Try it > free. > <http://pa.yahoo.com/*http://us.rd.yahoo.com/evt=36035/*http://music.yah > oo.com/unlimited/> > > > Please zip all files prior to uploading to Files section. > > > > > SPONSORED LINKS > Microsoft access developer > <http://groups.yahoo.com/gads?t=ms&k=Microsoft+access+developer&w1=Micro > soft+access+developer&w2=Microsoft+access+help&w3=Microsoft+access+datab > ase&w4=Microsoft+access+training&w5=Microsoft+access+training+course&w6= > Microsoft+access+programming&c=6&s=193&.sig=d-CjBIrYOH9NCKHYFeGZJA> > Microsoft access help > <http://groups.yahoo.com/gads?t=ms&k=Microsoft+access+help&w1=Microsoft+ > access+developer&w2=Microsoft+access+help&w3=Microsoft+access+database&w > 4=Microsoft+access+training&w5=Microsoft+access+training+course&w6=Micro > soft+access+programming&c=6&s=193&.sig=crx-d4AAhdklv_VozGVAUw> > Microsoft access database > <http://groups.yahoo.com/gads?t=ms&k=Microsoft+access+database&w1=Micros > oft+access+developer&w2=Microsoft+access+help&w3=Microsoft+access+databa > se&w4=Microsoft+access+training&w5=Microsoft+access+training+course&w6=M > icrosoft+access+programming&c=6&s=193&.sig=qg2hDuQNweByMCX0NU7cEA> > Microsoft access training > <http://groups.yahoo.com/gads?t=ms&k=Microsoft+access+training&w1=Micros > oft+access+developer&w2=Microsoft+access+help&w3=Microsoft+access+databa > se&w4=Microsoft+access+training&w5=Microsoft+access+training+course&w6=M > icrosoft+access+programming&c=6&s=193&.sig=bLZHqTqWUQny609X1OkmNA> > Microsoft access training course > <http://groups.yahoo.com/gads?t=ms&k=Microsoft+access+training+course&w1 > =Microsoft+access+developer&w2=Microsoft+access+help&w3=Microsoft+access > +database&w4=Microsoft+access+training&w5=Microsoft+access+training+cour > se&w6=Microsoft+access+programming&c=6&s=193&.sig=d8GQXfQW3RZ64rOfzIMo8A >> Microsoft access programming > <http://groups.yahoo.com/gads?t=ms&k=Microsoft+access+programming&w1=Mic > rosoft+access+developer&w2=Microsoft+access+help&w3=Microsoft+access+dat > abase&w4=Microsoft+access+training&w5=Microsoft+access+training+course&w > 6=Microsoft+access+programming&c=6&s=193&.sig=iXDlL79-kkgjv6fLyFu3Sg> > > ________________________________ > > YAHOO! GROUPS LINKS > > > * Visit your group "AccessDevelopers > <http://groups.yahoo.com/group/AccessDevelopers> " on the web. > > * To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED] >> > > * Your use of Yahoo! Groups is subject to the Yahoo! > Terms of Service <http://docs.yahoo.com/info/terms/> . > > > ________________________________ > > > > > > > Please zip all files prior to uploading to Files section. > Yahoo! Groups Links > > > > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/I258zB/QnQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
