I have the following situation, i have a disconnected recordset. and now in my client i want to search for a specific item.
It works fine but when i have a ' in my string it isn't working. thats ofcourse because of the ' in the string.
my code is the following
value = "it's a test"
RS.Find("field = '" & value & "'")
How can i solve my problem, is there an escape charater for this problem.