those are my insert statements but the bottom one is in red do you know why?VB Code:
StatSql = "INSERT INTO [Status] ([status], [description], [tool number], [date]) " & _ "Values ('" & cmbStatus.Text & "', '" & txtDesc.Text & "', '" & ToolID & "', '" & Date & "')" ToSQL = "INSERT INTO [Tool Data]([Tool Number],[Drawing Number],[Type of Tool], [Die Type], " & _ "[Date Created],[Vendor], [Department], [Tool Number assigned by],[PSketch],[Storage Location], [PMType]) " & _ VALUES('" & txtNum.Text & "', '" & txtDrNum.Text & "', '" & cmbTType.Text & "', '" & txtDie.Text & "', '" & _ & txtDate.Text & "', '" & cmbVendor.Text & "', '" & cmbDepart.Text& "', '" & txtAssign.Text & "', '" & _ & txtSketch.Text & "', '" & txtStore.Text & "', '" & txtPMType.Text & "')"




Reply With Quote