August 25th, 2013, 08:05 PM
I posted the explanation in post #13
The first mesage box is because of an instruction I wrote in the code, just to display the content of the sql query,remove it anytime you want...
The instruction to remove is : MsgBox strSQL
The second message is the error
The reason for this error are the single quotes characters ['] that are included in the paragraph that you click in the list box... example ("and weave the spider's web...") the error is caused by the ' character in spider's
Let me search for an alternative to find a record using single quotes in the text
... If your problem is fixed don't forget to mark your threads as resolved using the Thread Tools menu ...
Click Here to Expand Forum to Full Width