Error 3077 1

[fileman1]

I have a string variable LKS

If it contains the character ' eg It's, then the following line crashes, causing error 3077

' Is the word a keyword?
rs6.FindFirst "Keyword ='" & LKS & " '"

How can I stop this and any other character causing an error? Thanks

 

[ClulessChris]

it'll be the apostrophe try:

replace(LKS,"'","''")

Never knock on Death's door: ring the bell and run away! Death really hates that!

 

[fileman1]

Thanks, but I tried:

rs6.FindFirst "Keyword = replace(LKS," '","''")

rs6.FindFirst "Keyword =(LKS," '","''")

rs6.FindFirst "Keyword = LKS," '","''

 

[PHV]

rs6.FindFirst "Keyword='" & Replace(LKS, "'", "''") & "'"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[fileman1]

Thank you PHV, that fixed it. The code failed also further down the line, but with that syntax managed to sort all.

I just hope other characters entered as text don't make things fall over again, it was only because I used the character in a word that the fault appeared.