i have a textbox named AddU.text, i also have a msaccess table field named Quantity, what I want is that when i input a value in AddU.Text and click the add button, the value i entered will be automatically add to the existing value in Quantity. I keep searching for solution but can't find the right one. Can anyone help me? Heres my current codes:
Dim cmd As New OleDb.OleDbCommand If Not conn.State = ConnectionState.Open Then conn.Open() End If Try cmd.Connection = conn cmd.CommandText = "UPDATE BC_Inventory SET [Addition]='" + AddU.Text + "'," + _ "[Date_Updated]='" + DateU.Text + "',[Time_Updated]='" + TimeU.Text + "',[Updated_By]='" + UpdatedBy.Text + "'" + _ "WHERE [Item]='" + com_ItemU.Text + "'" cmd.ExecuteNonQuery() Catch ex As Exception MessageBox.Show(ex.Message, "Error") Finally conn.Close() End Try
actually i still have no codes for it, i keep trying the codes i found in researching but nothing helps thats why i deleted it.