title: how to store data from vb.net to access a database
body: <p>I am using an Access database and vb.net 2010. I have created a table in the database with columns for title, datein, dateout and roomnymber.  In vb.net 2010 I made a distinguished title = combobox, datein and dateout = DateTimePicker.  When I click on F5, an error occurs: INSERT INTO Syntax Error in statement. Here's my code:</p>
  
  <pre><code>Dim sql As String
    sql = "INSERT INTO tcekin(title,firstname,lastname,address,country,company,roomnumber,datein,dateout,rommtype,note)" &amp; "VALUES('" &amp; ComboBox1.Text &amp; _
    "','" &amp; txtFirstName.Text &amp; "','" &amp; txtLastName.Text &amp; "','" &amp; txtAddress.Text &amp; "','" &amp; cboCountry.Text &amp; "','" &amp; txtCompany.Text &amp; "','" &amp; txtNumber.Text &amp; _
    "','" &amp; dptDateIn.Text &amp; "','" &amp; dptDateOut.Text &amp; "','" &amp; cboRoom.Text &amp; "','" &amp; txtNotes.Text &amp; "')"
    cmmd = New OleDbCommand(sql, cnn)
  </code></pre>