Passing parameters to a stored procedure

S

Scamps

I have recently moved from developing an Access DB to
developing an Access.adp using SQL Server2000.
I havent been able to figure out how to pass a parameter
from a control in an Access form to a Stored procedure.
It was easy in Access but I just dont get it in
Access/SQL stored procedure.
Can anyone
a) tell me if this is possible
b) show me an example of how it is done.

btw, I get round the issue in most cases by using server
filter.
I use vba.
Regards
Scamps
 
R

Ragnar Midtskogen

You need to use an ADODB Comand object to run your stored procedure, it will
let you supply paramaters.
It is a bit involved, so look it up in Access help, or in the MSDN Library.

Ragnar
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Making form based on stored procedure 0
Pass-through query 2
multi-table select stored procedure subform ole eb error 2
Using Stored Procedures With Access Data Project 2
Passing an array parameter to forms Open Event 6
Passing Parameter with OnAction 3
sql stored procedure 1
Accessing Stored Procedure via VBA 4

Top