Recent content by gezrod

Sorted it, thank you pbaldy, sql1 = "exec UpdateNettTotalTester " & "'" & [ID] & "'" & "," & [Value1] & "," & [Value2] thank you again

Just had a thought the ID is text, the other two are int, what would the syntax be to surround the ID sql1 = "exec UpdateNettTotalTester " & [ID] & "," & [Value1] & "," & [Value2]

Thank you again Pbaldy, I still get a syntax error sql1 = "exec UpdateNettTotalTester " & [ID] & "," & [Value1] & "," & [Value2]

Thanks Pbaldy, that works a treat with typed values, can I pass values from an access form ? i.e. sql1 = "exec UpdateNettTotalTester [id],[val1],[val2]" Tried it and get syntax error . .

I have created a stored procedure "UpdateValues" to update 2 columns in a record which matches a specific ID The stored procedure executes fine in sql manager. I am trying to execute the stored procedure within access VBA by providing the ID initially and the 2 other parameters which the...