Help with SQL INSERT commands

[chris.williams]

I have a form which is linked to table_1. When the form is processed via a command button, I want to take value_1 and value_2 of table_1 and insert them to value_1 and value_2 of table_2.

The tables are not linked, and have no relation at all.



I am having problems with the SQL syntax - any help would be appreciated.

DoCmd.RunSQL (INSERT INTO table_2 (value_1,value_2) VALUES value_1,value_2)

[pbaldy]

DoCmd.RunSQL "INSERT INTO table_2 (Field_1,Field_2) VALUES (value_1,value_2)"

[chris.williams]

Thanks - I tried that as well as this:

DoCmd.RunSQL "(INSERT INTO tbl_IssuedCertificates (CertNumber,DesignConsultant) VALUES " & Me.CertNumber & "," & Me.DesignConsultant & ")"

and I still get syntax errors.

[chris.williams]

This too didn't work:

DoCmd.RunSQL "(INSERT INTO tbl_IssuedCertificates (CertNumber,DesignConsultant) VALUES (" & Me.CertNumber & "," & Me.DesignConsultant & ")"

[chris.williams]

It's the afternoon. My eyes are tiered. I have found the syntax errors and have gotten working. Thanks Paul.

[pbaldy]

Well, you missed the opening parentheses for the VALUES clause on the first. You have an extra opening parentheses at the beginning of both that I didn't have, and that shouldn't be there. You need delimiters if any field is text. This should help debug the SQL:

http://www.baldyweb.com/ImmediateWindow.htm

And this will help with the delimiters either field is text:

http://www.baldyweb.com/BuildSQL.htm

[pbaldy]

Oops, posting at the same time. Glad you got it sorted out.