Error on INSERT INTO string built with VBA

[sstiebinger]

I'm building out a test database to build proposals from a parts list, and I've run into an issue here when I'm trying to add a part to a proposal.


I've attached a copy of the database with pricing changed to protect the innocent.

If you open frmProposal there's a subform with a button to add a part to the proposal.
That button opens the parts list selector continuous form.... double-clicking any individual line on that selector form should add that line item to the individual proposal.
However, when I try to click it, my code is spitting back that the query is missing an operator, and I can't for the life of me figure out what I'm missing.

Any help appreciated.

[ItsMe]

You have several issues. One is that you seem to be using variables to determine column names in your SELECT statement. Do you have a column named '1'?

Another issue is that you are using parenthesis on your SELECT statement incorrectly. I do not see a need for them with that statement, leave them out. Here is an example using INSERT INTO with a SELECT statement.

INSERT INTO TableOne (FieldOne, FieldTwo, FieldThree)
SELECT FieldName1, Fieldname2, FieldName3
FROM TableTwo
WHERE FieldName5 = 200;

[sstiebinger]

The variables are used for hard-coded values, not selected values from the table.
i.e.

INSERTINTO Movies (Title, Director, Cost, Profits)
SELECT'Star Wars', name,50000,1000000
FROM Directors WHERE name ='Lucas'

Where the only item actually populated from "Directors" would be NAME... the other items just being values inserted into the fields.

[sstiebinger]

So I got rid of the Parens which helped by changing the error message.
This led me to realize that I had missed a comma between PartID and InstallationHours.

The solution is working now.

Thanks for the help.

[ItsMe]

Glad you were able to work through it.

In case you are not aware of debugging your SQL as a troubleshooting method ...
http://www.baldyweb.com/immediatewindow.htm