Unfortunately when I did copy the statement the forum displayed it the way you currently see it. In actuality it is indeed all one line and all the commas are in place. here it is again...
Working Original,
sSQL = "INSERT INTO tblAuthor (Username,User_code,Password,Author_email) VALUES ('" & objRec("fldUserName") & "','" & code & "','" & objRec("fldPassword") & "','" & objRec("fldEmail") & "')"
con.Execute(sSQL)
NonWorking Changed but almost Identical,
sSQL = "INSERT INTO tblAuthor (Username,User_code,Password,fldGroupNumber,Author_email,fldTitle,fldFirstName,fldLastName,fldRank,f ldOrg,fldPhone,Join_date) VALUES ('" & objRec("fldUserName") & "','" & code & "','" & objRec("fldPassword") & "','" & objRec("fldGroupNumber") & "','" & objRec("fldEmail") & "','" & objRec("fldTitle") & "','" & objRec("fldFirstName") & "','" & objRec("fldLastName") & "','" & objRec("fldRank") & "','" & objRec("fldOrg") & "','" & objRec("fldPhone") & "','" & objRec("fldWhen") & "')"
con.Execute(sSQL)
:confused: