X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Stored Procedure Pass Parameters Via Form, Access 2010    
post Jan 28 2015, 10:08 AM

Posts: 1
Joined: 28-January 15

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

Go to the top of the page
post Feb 27 2015, 01:06 PM

UtterAccess Moderator
Posts: 12,263
Joined: 6-December 03
From: Telegraph Hill

Hi, and belated welcome to UA!

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

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

See here on MSDN 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.


Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    19th February 2020 - 06:19 AM