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 -----
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




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




Reply via email to