By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,998 Members | 2,903 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,998 IT Pros & Developers. It's quick & easy.

Error in Database vb

P: 27
[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.txtTimeStart.Text & "'," & _
" '" & frmDisplay.txtTimeEnd.Text & "','" & frmDisplay.lblAverage.Caption & "','" & frmDisplay.lblNum.Caption & "')"
DE.Conn.Execute strSql1
End If
Resume Next
End If
Apr 27 '08 #1
Share this Question
Share on Google+
2 Replies


lotus18
100+
P: 866
May I see your database connection.

Rey Sean
Apr 27 '08 #2

Expert 100+
P: 487
Check 'TimeStart' Field is available in your table?
Note: As Rey told, Check the connection string is connected the current database.
Apr 28 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.