Access 2003 .adp: How to include parameter in OpenStoredProcedure

E

Eaton

Hi,

I'm using Access 2003 .adp.
I'm trying to used the DoCmd.OpenStoredProcedure and pass a string paramter
like: DoCmd.OpenStoredProcedure "spXYZ 'parm1". When I specify just the
procedure name and omit the parameter, it prompts me for the paramter, which
I fill in and then it runs correctly. I don't want the prompt.
This is different than the InputParamter property for a form.
There's got to be a way to specify the parameter in VBA so the user is not
prompted for it.
Any ideas?

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

multi-table select stored procedure subform ole eb error 2
OpenStoredProcedure 2
Form not passing parameter to query 2
Stored Procedure, Forms and Input Parameters 3
InputParameter - compatibility 2003 - 2007 issue 1
InputParameter - compatibility 2003 - 2007 ? 0
How to Create Parameter in Access Form 4
subform rowsource pass through to table value function w/ paramete 0

Top