Printable Version of Topic

Click here to view this topic in its original format

UtterAccess Forums _ Access Data Projects - ADP _ Stored Procedure Pass Parameters Via Form

Posted by: ayh1 Jan 28 2015, 10:08 AM

Hi I have a stored procedure created in SQL SERVER 2008r2

I have a form in access with combo boxes, when I click the submit button I want the values chosen to be the parameters and the stored procedure called to generate a report

is this possible

thanks

Posted by: cheekybuddha Feb 27 2015, 01:06 PM

Hi, and belated welcome to UA!
welcome2UA.gif

Please note that ADP's are now deprecated (obsolete technology in Access)

However, yes you can pass parameters to your Stored Proc.

https://msdn.microsoft.com/en-us/library/office/aa160569%28v=office.11%29.aspx for some guidance.

You mention that you are using Access 2010. I thought they did not have ADP's. If you are just using straight Access to connect to your SQL server then search UA for 'Passthrough Queries' which will be what you will need to use.

hth,

d