Passing parameter data to stored procedure using VBA?

  • Thread starter Thread starter dsstao
  • Start date Start date
D

dsstao

Hi all,

I have a stored procedure that includes parameters. I also have a form
that the user can specify criteria on. The problem is, how do I pass
along this info from the form, via VBA, into the parameters of the
stored procedure?

Thanks!
DS
 
Hi all,

I have a stored procedure that includes parameters. I also have a form
that the user can specify criteria on. The problem is, how do I pass
along this info from the form, via VBA, into the parameters of the
stored procedure?

Thanks!
DS
Click to expand...

Hi DS
you have 2 options:

1) the stored proc is the data source of a form
In this case to pass parameters you can use the InputParameters property of
the form.
In the Open event you can write

me.InputParameters= "@param1 int = forms!Frm_Criteria!TextBox1, @param2
varchar(50) = forms!Frm_Criteria!TextBox2"
or
you can write this string directly in the InputParamters property of the
form

2)you have to run a stored proc who does some work, not associated to any
form.
In this case you can use something like this:

CurrentProject.Connection.Execute "sp_ProcName(" &
forms!frmCriteria!txtBox1 & ", " & forms!Frm_Criteria!TextBox2 & ")"
depending on parameters type you should enclose the parameters between " ' "

For more help the right ng is microsoft.public.access.adp.sqlserver

Bye
 
Back
Top