Error in Database vb

[JuAn2226]

[ODBC MICROSOFT DRIVER] The INSERT INTO statement contain unknown file name: 'TimeStart'

i realy no idea how to solve this error because the TimeStart is excatly the name i use in the Results table. plz guide me.


If myvari = vbOK Then

strSql1 = "INSERT INTO Results (TimeStart, TimeEnd, AverageSpeed, NumberOfCar)" & _
" VALUES ('" & frmDisplay.txtT imeStart.Text & "'," & _
" '" & frmDisplay.txtT imeEnd.Text & "','" & frmDisplay.lblA verage.Caption & "','" & frmDisplay.lblN um.Caption & "')"
DE.Conn.Execute strSql1
End If
Resume Next
End If

[lotus18]

May I see your database connection.

Rey Sean

[CyberSoftHari]

Check 'TimeStart' Field is available in your table?
Note: As Rey told, Check the connection string is connected the current database.