Error: data type mismatch criteria expression

Asked Jan 14 '14 at 17:34

Active May 24 '15 at 15:02

Viewed 99 times

This is my problems at VB.net 2012, when I'm run, show this error: data type mismatch criteria expression

Public Sub AddPOS()
    vatAmount = Format((lblTotalCost.Text * 0.12), "#,##0.00")
    nonVatAmount = Format(lblTotalCost.Text - vatAmount, "#,##0.00")
    Try
        sqL = "INSERT INTO POS(InvoiceNo, POSDate, POSTime, NonVatAmount, VatAmount, TotalAmount, StaffID, CustomerNo) VALUES('" & lblInvoiceNo.Text & "', '" & Format(Date.Now, "Short Date") & "', '" & Format(Date.Now, "Long Time") & "', '" & nonVatAmount & "', '" & vatAmount & "', '" & lblTotalCost.Text & "', '" & frmMain.lblEmployeeNo.Text & "'," & Val(lblCustomerNo.Text) & ")"
        ConnDB()
        cmd = New OleDbCommand(sqL, conn)

        cmd.ExecuteNonQuery()
    Catch ex As Exception
        MsgBox(ex.Message)
    Finally
        cmd.Dispose()
        conn.Close()
    End Try
End Sub

edited May 24 '15 at 15:02

Delimitry

2,987
4
30
39

asked Jan 14 '14 at 17:34

user3194980

This might be a [quotes/no-quotes issue](http://stackoverflow.com/questions/11087698/what-should-i-do-in-data-type-mismatch-in-criteria-expression)... – summea Jan 14 '14 at 17:36
1

so, what should I fix? :/ – user3194980 Jan 14 '14 at 17:47
Unless you provide more details about your database column types, the exercise may be left up to you :) – summea Jan 14 '14 at 17:55

Error: data type mismatch criteria expression

0 Answers0