I am using Excel vba form to connect to a mysql table. My form has several textboxes that can be updated. I am using the following UPDATE statment, but am getting a runtime error message about the syntax. In the error message box, however, my statement is reading as I would expect it to.
usqlstring = "(UPDATE company set company = REPLACE('" & ucompany & "' WHERE prospect_id='" & updateid & "'))"
' Assign the Connection object.
.ActiveConnection = cnnt
' Tidy up
Set rs = Nothing
Set cnnt = Nothing
Thanks for the help -