DoCmd.OpenStoredProcedure - passing parameters?
Posted on 2004-09-16
In my ADP I have a couple places where I call DoCmd.OpenView so that my users can see some data in "raw" form (for copying to a spreadsheet, etc.). I've been able to use DoCmd.OpenView successfully with filters to limit the results.
Now I want to do the same thing, but instead of a view, I need a stored procedure because the query is too complicated to simply use filters for the limiting (I'm doing grouping, a subselect, etc). So I see that DoCmd.OpenStoredProcedure exists, but the access documentation doesn't explain how I can pass in my parameters.
Thanks for any help.