SQL in VBA Problem. Semantics?

[karassik]

Hello and thank you for looking at my problem.

I get an error stating that "number of query values and detinations are not the same.

Can anyone tell me what is wrong with the following code in Access 2000 written in VBA:

Dim stSQL As String

DoCmd.SetWarnings False
stSQL = "INSERT INTO [tblTempRmgAdd]([JobID],[Design],[ProTrodes])"
stSQL = stSQL + " values ('" & Me.JobID & " ," & Me.Design & " ," & Me.ProTrodes & "');"
DoCmd.RunSQL stSQL
DoCmd.SetWarnings True

 

[AWithers]

I think you need to look at the values statement again...any text field needs to be surrounded with quotes

e.g. (presuming jobid is numerical and the other fields are text)

try this


stSQL = "INSERT INTO tblTempRmgAd](JobID,Design,ProTrodes)"
stSQL = stSQL + " values (" & Me.JobID & " ,'" & Me.Design & "' ,'" & Me.ProTrodes & "');"

 

[m6]

Dear Karrasik,

Looks like you have a set of single quotes near the parens.().

Give it a shot.

Tx,

M6

 

[OldTom]

Dear Karrasik,

Do any of your text fields actually contains either single or double quotation marks - ' or ".

A quick way of checking your sql is to display it via msgbox just before the DoCmd.RunSQL stSQL