visual basic data type mismatch in criteria expression??

[chili007]

i cant find the problem can anyone help me pls???


If userNameTextBox .Text <> "" Then
Dim sqlQRY As String = "INSERT INTO SalesOrder Values ('" & salesNoTextBox. Text & "', '" & orderDateTextBo x.Text & "', '" & userNameTextBox .Text & "', '" & productCodeText Box.Text & "', '" & quantityTextBox .Text & "')"
Try
conn.Open()
Dim cmd As OleDbCommand = New OleDbCommand(sq lQRY, conn)
cmd.ExecuteNonQ uery()
Catch ex As OleDbException
MsgBox("Error: " & ex.ToString & vbCrLf)
Finally
conn.Close()
End Try
saveButton.Enab led = False
Else
MsgBox("Please select customer")
userNameTextBox .Focus()
End If

[Rabbit]

It's probably because you're trying to insert a string into that date field. But I have no idea because you haven't told us what the data types are for your fields.

[chili007]

i am doing a sales order form. pls help!!!

[Rabbit]

I did help. I helped all I could given the information that was provided.

[chili007]

so may i know which code i have to change?

[Rabbit]

I don't know what you have to change. I can only guess at the error because I don't have everything I need to know to pinpoint the error.

[nirgunpratik]

Try this and let me know if it works.....

"INSERT INTO SalesOrder Values ('" & salesNoTextBox. Text & "', '" & Convert.ToDateT ime(orderDateTe xtBox.Text) & "', '" & userNameTextBox .Text & "', '" & productCodeText Box.Text & "', '" & quantityTextBox .Text & "')"

[Killer42]

I wonder whether putting hashes (#) around the date value might help.

But yeah, what we really need is more info about the circumstances.