pass a variable to an SQL stored procedure

[mbair]

I need to call an SQL stored procedure and pass it a value and then have the procedure execute. How do I do this from Access????

 

[cmmrfrds]

How are you using the stored procedure? What does it return? A resultset or parameter? Is it bound to a Form or Report? Other?

 

[jsteph]

mbair,
If you're just running something that executes and doesn't return anything to you, just call it with a pass-thru query.

Assuming the example params fit string data types, adjust for numeric, etc., when you create the string:

Dim qd as querydef,strSQ as string
set qd = currentdb.querydefs("mypassthru")
strSQ = "Exec dbo.SomeProcedure '" & somevar & "','" & someothervar & "'"
qd.sql = strsq
qd.execute

--jim