J
Jack
Hi,
I have a sql server stored procedure that is being used by a Access form.
Parameter is being passed through a intermediate form and based on parameter
values the result form displays the data set. Now I have been asked to add
few more fields in the result form. Hence I had to add the same fields in the
stored procedure. When I am running this modifed stored procedure from QA I
am getting the correct result. However, in the Access result form the added
fields are showing #error. Thus the result set gives partial results
correctly(previous fields) while the added fields are showing #errors. I
have exhausted all my options to know where the problem is. I would
appreciate any help to resolve this issue. Thanks in advance.
I have a sql server stored procedure that is being used by a Access form.
Parameter is being passed through a intermediate form and based on parameter
values the result form displays the data set. Now I have been asked to add
few more fields in the result form. Hence I had to add the same fields in the
stored procedure. When I am running this modifed stored procedure from QA I
am getting the correct result. However, in the Access result form the added
fields are showing #error. Thus the result set gives partial results
correctly(previous fields) while the added fields are showing #errors. I
have exhausted all my options to know where the problem is. I would
appreciate any help to resolve this issue. Thanks in advance.