Access Lookup Problem

Trob70 · Jul 13, 2015

I am having a problem with the following line

sql2 = "SELECT * FROM [wol] WHERE trim([Title]) = '" & Trim(TextBox4.Text) & "' and trim([publisher]) = '" & Trim(TextBox8.Text) & "' and trim(

Code:

) = '" & Trim(TextBox7.Text) & "' and trim([composer]) = '" & Trim(TextBox9.Text) & "'"



The problem is   The Textbox8.text  is eg isn't it  (for example)

ie  the is a  '    in the lookup

The program bombs out

is there a way of doing a lookup  with a  '   in texttbox i am using for the lookup


Appreciate any help


Trob70

jbenson001 · Jul 13, 2015

First of all, I suggest you use stored procedures.
Second, you have to replace any single quote ("'") with double single quotes ("''")

Trob70 · Jul 13, 2015

jbenson001

Thanks for your advice.....

Did not realize that ado had this problem Have allways been use Dao in vb6

Thanks for you advice

Regards Trob70

jbenson001 · Jul 14, 2015

Glad to help.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Access Lookup Problem

Trob70

Programmer

jbenson001

Programmer

Trob70

Programmer

jbenson001

Programmer

Similar threads

Part and Inventory Search

Sponsor