am not sure, this is your question however the correct syntax would be like below
Quote:
str = "Insert into ServiceRecords([ClientName],[Address],[TimeStarted],[TimeEnded],[OpDate],[FloorDrain Quantity],[FloorDrain Clogged],[FloorDrain F/R]) Values(?,?,?,?,?,?,?,?)"
str = "Insert into ServiceRecords([ClientName],[Address],[TimeStarted],[TimeEnded],[OpDate],[FloorDrain Quantity],[FloorDrain Clogged],[FloorDrain F/R]) Values(@ClientName,@Address,@TimeStarted,@TimeEnded,@OpDate,@FloorDrainQuantity,@FloorDrainClogged,@FloorDrainFR)"
cmd.Parameters.Add(New OleDbParameter("@ClientName", CType(clientNameText.Text, String)))
cmd.Parameters.Add(New OleDbParameter("@Address", CType(addressText.Text, String)))
cmd.Parameters.Add(New OleDbParameter("@TimeStarted", CType(timeStartedText.Text, String)))
cmd.Parameters.Add(New OleDbParameter("@TimeEnded", CType(timeEndedText.Text, String)))
cmd.Parameters.Add(New OleDbParameter("@OpDate", CType(datePicker.Text, Date)))
cmd.Parameters.Add(New OleDbParameter("@FloorDrainQuantity", CType(fldQuantityText.Text, String)))
cmd.Parameters.Add(New OleDbParameter("@FloorDrainClogged", CType(fldClcbox.CheckState, Boolean)))
cmd.Parameters.Add(New OleDbParameter("@FloorDrainFR", CType(fldFinRecText.Text, String)))