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/> . ________________________________ ------------------------ Yahoo! Groups Sponsor --------------------~--> Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/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/
