using store procedure as recordsource

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Roy Goldhammer - 25 Jun 2007 08:44 GMT

Hello there

If i have store procedure with parameters, can i use it as record souce
without the enter parameter value to be opened and the data will be taken
from the current form

Reply to this Message

PBsoft - 25 Jun 2007 15:26 GMT

> If i have store procedure with parameters, can i use it as record
> souce without the enter parameter value to be opened and the data will
> be taken from the current form

Yes, you can.

As form RecordSource property you have to specify something like:

schemaname.spname

then as form InputParameter you have to specify all parameters, in a form
like this:

@parametername parametertype = valueforparameter, .......

--
PBsoft di Gabriele Bertolucci
www.pbsoft.it
skype:pbsoftsolution

Reply to this Message

Malcolm Cook - 26 Jun 2007 18:53 GMT

also, if stored proc is the record source of a subform, and the parameters to the stored procedure are exactly identical to the
names of variables on the main form, then access will automagically pass them to the stored proc for you.

Signature

Malcolm Cook
Stowers Institute for Medical Research - Kansas City, MO USA

>> If i have store procedure with parameters, can i use it as record
>> souce without the enter parameter value to be opened and the data will
[quoted text clipped - 14 lines]
> www.pbsoft.it
> skype:pbsoftsolution

Reply to this Message