Last post Apr 09, 2008 04:27 AM by Mikesdotnetting
Apr 08, 2008 03:26 PM|patriot_david|LINK
I am trying to delete a record from the an order table when i click a button. I am using the following code:
I have a problem with the execute command, can anyone help?
Apr 08, 2008 04:03 PM|senthilselvan|LINK
can you post the error message?
Apr 09, 2008 04:27 AM|Mikesdotnetting|LINK
At the moment, your Order_ID value has apostrophes around it, which tells Access to expect a string, but my guess is that Order_ID is a number datatype. Remove the apostrophes:
Where ORDER_ID = " & TextBox1.Text, New OleDbConnection...., or better still, use parameters: