Using named parameters with stored procedures (ADO 2.7, Access ADP, SQL SVR 2000 and VBA)
Posted on 2004-03-22
I was under the impression that utilizing named parameters I could only specify the parameters needed and execute with those leaving others blank.
I have a large Access form that I need to be able to save as incomplete and come back to it later to finish. I have update and insert stored procedures defined to do this and I am using code to create and append parameters to the appropriate stored procedure as necessary. However, I am getting an error that the stored procedure expects a parameter that was not supplied.
I am thinking that I need default values but am not sure how to use the value already in the table or Null as default.