Store Procedure with Parameters

[Jonathan Blitz]

I have a report where I want to use a complicate SP as the recordsource.

The SP needs to get paramters but I don't want the user to be prompted for
the values.

Is there any way I can send this paramters from insode the VBA code?

Jonathan Blitz
AnyKey Limited
Israel

 

[David Lloyd]

Jonathan:

If your using an Access Data Project, the following KB article may be
useful. If not, maybe you can give some additional details of your
implementation.

http://support.microsoft.com/default.aspx?scid=kb;en-us;300693

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I have a report where I want to use a complicate SP as the recordsource.

The SP needs to get paramters but I don't want the user to be prompted for
the values.

Is there any way I can send this paramters from insode the VBA code?

Jonathan Blitz
AnyKey Limited
Israel