whats wrong with this:
it stops on the lineCode:Dim Cmd As New System.Data.OleDb.OleDbCommand() con.Open() Cmd.Connection = con Cmd.CommandText = " INSERT INTO TblContacts ('" & Night & "') VALUES " & "('Harry') WHERE (Phone = '" & incomingtextno & "')" Cmd.ExecuteNonQuery() con.Close()
Cmd.ExecuteNonQuery()
telling me i need a colon somewhere. however i havent needed one in the past using sql and vb.net???




Reply With Quote