safeerbinsalih
Registered User.
- Local time
- Tomorrow, 04:11
- Joined
- Dec 30, 2015
- Messages
- 26
I'm trying to insert today's date into a table using SQL. But run-time error 3067 is popping out
strSQL = "INSERT INTO tblECO (Release_date)" & vbCrLf & " VALUES (Now()) WHERE ECO_number = (" & E & ")"
db.Execute strSQL, dbFailOnError
In the above code Release_date is date/time(short date) variable and E is Long(double) variable.
Any help is appreciated. Thank you
strSQL = "INSERT INTO tblECO (Release_date)" & vbCrLf & " VALUES (Now()) WHERE ECO_number = (" & E & ")"
db.Execute strSQL, dbFailOnError
In the above code Release_date is date/time(short date) variable and E is Long(double) variable.
Any help is appreciated. Thank you