Re: [AccessDevelopers] SPECIAL CHARACTER

[brij]

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 To: AccessDevelopers@yahoogroups.com 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 Microsoft access help Microsoft access database Microsoft access training Microsoft access training course Microsoft access programming Yahoo! Music Unlimited - Access over 1 million songs. Try it free. May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at ==> http://www.prodev.us   Yahoo! Music Unlimited - Access over 1 million songs. Try it free. Please zip all files prior to uploading to Files section. SPONSORED LINKS Microsoft access developer Microsoft access help Microsoft access database Microsoft access training Microsoft access training course Microsoft access programming YAHOO! GROUPS LINKS  Visit your group "AccessDevelopers" on the web.    To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.