I been searching for days for a sulotion but can't seem to find one.
The coed that I have does not give me an error but it does not save anything on the table either '
Can someone help me find what I'm missing?
this is my coed
Dim mycon As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\DEsign.accdb" Dim customer As String = "select * from Customer_tbl" Dim Notes As String = "select * from Notes_tbl" Dim con As New OleDb.OleDbConnection(mycon) Dim comCustomer As New OleDb.OleDbCommand(customer, con) Dim comdNotes As New OleDb.OleDbCommand(Notes, con) Dim Custsql As String = "first name,Last Name" Dim Sql As String = "insert into Customer_tbl (Custsql )values '" & txtFirstName.Text & "','" & txtLastName.Text & "')" comCustomer = New OleDb.OleDbCommand(Sql, con) con.Open() comCustomer.ExecuteNonQuery() comCustomer.Dispose() con.Close()