help with insert into statement

[short]

Can someone help me with what's wrong with this insert into statement?

SoftwareID = "SELECT Software.[ID] FROM Software where Software.[Name] = '"
+ cmbSoftware.Value + " AND ServerID = '" + ServerID = "';"
(this comes from a combo box)

nodeID = ID

Dim sql As String
sql = "INSERT INTO Node_Software ( [NodeID] [SoftwareID])
Values (""" & nodeID & SoftwareID & """)"
MsgBox sql
DoCmd.RunSQL sql

 

[Stefan Hoffmann]

hi Shorty,

Dim sql As String
sql = "INSERT INTO Node_Software ( [NodeID] [SoftwareID])
Values (""" & nodeID & SoftwareID & """)"
MsgBox sql
DoCmd.RunSQL sql

Missing commas:

"INSERT INTO Node_Software([NodeID], [SoftwareID]) " & _
"VALUES ('" & nodeID & "', '" & SoftwareID & "')"


mfG
--> stefan <--

 

[short]

thanks so much!

hi Shorty,

Dim sql As String
sql = "INSERT INTO Node_Software ( [NodeID] [SoftwareID])
Values (""" & nodeID & SoftwareID & """)"
MsgBox sql
DoCmd.RunSQL sql

Missing commas:

"INSERT INTO Node_Software([NodeID], [SoftwareID]) " & _
"VALUES ('" & nodeID & "', '" & SoftwareID & "')"


mfG
--> stefan <--