Visual Basic&database, Type Mismatch error 13

Type Mismatch error 13

Author	Message
Mauri Kovalaine #1 / 3	Type Mismatch error 13 What is the correct syntax for SQL-query in this case? Qry = " INSERT INTO MyTable (Date,Time, Value ) VALUES ("+ Date+","+Time+", "'+Val(txtValue.text)+");" Name - field gets information from textfield (txtValue.Text) , date and time come from system. I am using Access database where Value-field datatype is Number. When I try to do this I get error number 13.
Mon, 25 Sep 2000 03:00:00 GMT

BBello57 #2 / 3	Type Mismatch error 13 Quote: Mauri wrote... >What is the correct syntax for SQL-query in this case? >Qry = " INSERT INTO MyTable (Date,Time, Value ) VALUES ("+ Date+","+Time+", >"'+Val(txtValue.text)+");" >Name - field gets information from textfield (txtValue.Text) , date and time >come from system. >I am using Access database where Value-field datatype is Number. >When I try to do this I get error number 13. Use & instead of + to do your concatenation. Just replace your + with & Good luck Bosun http://members.aol.com/bbello5778/bosun.htm Programmer/Analyst. Bloomington, IL
Mon, 25 Sep 2000 03:00:00 GMT

Page 1 of 1

[ 3 post ]