trying to run this:
Code:
strSQL = "INSERT INTO dbo_tblSubmittals(DetDBID, JobNum, Segment, Detlr, Desc, DetWgt, Comments, ReqSubDate, PropSubDate) " & _
"VALUES('" & strDetDBID & "', '" & strCurrJobNum & "', '" & strSegment & "', '" & strEmpName & "', '" & Me.txtDesc.value & "', " & Me.txtDetWgt.value & ", '" & Me.txtNotes.value & "', #" & Me.txtReqSubDate.value & "#, #" & Me.txtPropSubDate.value & "#)"
Debug.Print strSQL
dbCMC.Execute strSQL, dbFailOnError
and it keeps giving me a syntax error (3134). I'm getting this out of the debug:
Code:
INSERT INTO dbo_tblSubmittals(DetDBID, JobNum, Segment, Detlr, Desc, DetWgt, Comments, ReqSubDate, PropSubDate) VALUES('CTX', '1123705000', 'Level 2', 'Eric', 'BEAMS', 51000, 'test1', #4/7/2011#, #4/7/2011#)
I don't see anything wrong there but maybe I've been looking at it too long, suggestions?