Passing parameters to a stored procedure

  • Thread starter Thread starter Scamps
  • Start date Start date
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
 
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
 
Back
Top