Run-time error '3134'
Syntax error in INSERT INTO statement
I was trying to give an example of my INSERT INTO statement to keep it short, but here is the actual statement:
DoCmd.RunSQL (" insert into labels (trknum, BC2, Date, catalog, intid, _
cavity, pressnum, cyclenum) values (" & mtxt0 & ", '" & mtxt9 & "', _
#" & CStr(mtxt2) & "#, '" & mtxt4a & "', " & mtxt6a & ", '" & mtxt8a & "', _
" & mtxt14 & ", " & mtxt18 & ")"sorry about the length of this
Here's to alcohol...the cause of ... and solution to ... all of life's problems - - Homer J. Simpson
