Too few Paramaters. Expected 2.

[sheusz]

Hi all



I know this is a syntax issue, but I am struggling to get this statement correct. I have been working on it for hours and am hoping that someone can show me where I am going wrong.

strSQL = "UPDATE [xServices] SET [Onsite Contact] = [Onsite Contact] & ExtNewOnsiteContact WHERE xServices.[MachineNo] = '" & MachineID & "'"

Table xServices contains Long Text field [Onsite Contact] yes, I know about spaces and field names.

I want to concatenate [Onsite Contact] & ExtNewOnsiteContact and replace the existing value of [Onsite Contact] where the value of x.Services.[MachineNo] is equal to MachineID.

MachineID = [Forms]![Training & Services]![Machine No]

When I Debug.Print strSQL I get this
UPDATE [xServices] SET [Onsite Contact] = [Onsite Contact] & ExtNewOnsiteContact WHERE xServices.[MachineNo] = '1215-1490'

but frankly, I'm not sure what I am expected to see.


In this case MachineID is 1215-1490, so I know that part is correct, so it's probably the concatenation that is wrong.

Thank you in advance.

[Gicu]

Not sure what ExtNewOnsiteContact is but I assume is either a string variable or a form control name, so maybe try:

strSQL = "UPDATE [xServices] SET [Onsite Contact] = [Onsite Contact] & '" & ExtNewOnsiteContact  & "' WHERE xServices.[MachineNo] = '" & MachineID & "'"

You should also check the name of the MachineNo field in the table, in the form you show it with a space so that might be another part of the error message.

Cheers,

[sheusz]

Not sure what ExtNewOnsiteContact is but I assume is either a string variable or a form control name, so maybe try:

strSQL = "UPDATE [xServices] SET [Onsite Contact] = [Onsite Contact] & '" & ExtNewOnsiteContact  & "' WHERE xServices.[MachineNo] = '" & MachineID & "'"

You should also check the name of the MachineNo field in the table, in the form you show it with a space so that might be another part of the error message.

Cheers,

Thank you for the reply. Your solution was correct on two counts. The syntax, and the xServices.[MachineNo] field is actually xServices.[Machine No]. Talk about missing the bleeding obvious.

Very much appreciate your help. Have a great day.

[Gicu]

You're very welcome!
Cheers,