DoCmd.OpenStoredProcedure with Parameters

A

Arun Subramanian

Hi,
I am trying to use the DoCmd.OpenStoredProcedure to open a stored procedure
with the parameter from the FORM.

Like..

CREATE PROCEDURE MyProc (@MyID INT) AS

SELECT * FROM Temp WHERE ID = @MyID

RETURN
GO

From the Screen, I will be getting the ID as the user selection and I have
to open it in the view of the command button CLICK.

DoCmd.OpenStoredProcedure "MyProc " & Form!ctlList.Value, acViewPreview,
acReadOnly

Any help??

Thanks,
AS
 

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

DoCmd.OpenStoredProcedure won't display altered proc 4
Stored Procedure "...did not return records" Error in Access 2007 2
Create a stored procedure from VBA in order to use DoCmd.OpenStoredProcedure with arguments 1
Refreshing Project Connection Using VBA 0
Cannot show a resultset produced by a stored procedure 2
Stored procedure 6
insert a crosstab in to temp table query 2
Run code by clicking on a label - Not working 1

Top