Stored Procedures in Datasheet View

J

JH Szymanski

Is there any generalized way to display the recordset
returned from a stored procedure with parameters in a
datasheet view? DoCmd.OpenStoredProcedure doesn't seem to
allow any parameters for the sp to be specified. The
methods in KB Article #235359 work; however, that method
would require pre-defining a form for each stored
procedure to be run -- I am looking for something more
general. As a workaround, is there any way to invoke the
AutoForm wizard from VBA to auto-create the form on-the-
fly?

Any ideas would be appreciated. Thanks...
 

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

Cannot show a resultset produced by a stored procedure 2
Create a stored procedure from VBA in order to use DoCmd.OpenStoredProcedure with arguments 1
How to get Textbox dates into Stored Procedure 5
Upsizing Head Scratcher - Datasheet Subform 8
Recordset from stored procedure with parameters 1
Passing Form input to stored procedure to populate a report 8
Access 2002 .adp subform linking using stored procedures 1
Adding records using form based on stored procedure? 3

Top