Stored Proc. Parameters

E

Eric

Hi,

I have a report that aquires data from a stored procedure.
This stored proc. requires 4 parameters. These parameters
are based on values supplied by a form.

The problem is I put the values from the form into VB
variables. I would like to send these variables as the
parameters of the strd proc. I've tried a couple of
things, but everytime I try to make a relation to the
variable, Access prompts me with an input box.

How can I make it just use a public variable.

TIA,
Eric
 
D

Douglas J. Steele

If you're talking about using, say, a SQL Server stored procedure via a
pass-through query, you can't get it to recognize fields or variables in
Access. This is because pass-through queries run on the server: they don't
know anything about what's happening in your application. What you have to
do is change the SQL associated with the pass-through query to include the
parameter values, then submit it.
 

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

Input Parameters on Stored Proc. 3
getting return value from stored proc 4
how to pass parameters from forms to stored procedures 21
Execute SQL Stored Proc from Access 1
Using Stored Procedures With Access Data Project 2
Referncing stored proc from a form 2
ERROR 2757 IN ADE BASED FORM BUT NOT ADP BASED FORM 0
DoCmd.OpenStoredProcedure won't display altered proc 4

Top