UtterAccess.com
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    
 
   
ayh1
post Jan 28 2015, 10:08 AM
Post#1



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

thanks
Go to the top of the page
 
cheekybuddha
post Feb 27 2015, 01:06 PM
Post#2


UtterAccess VIP
Posts: 9,275
Joined: 6-December 03
From: Telegraph Hill


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.

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.

hth,

d
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    11th December 2017 - 05:53 PM