By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,846 Members | 1,252 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,846 IT Pros & Developers. It's quick & easy.

stored procedures with parameters (in .adp)

P: n/a
I use a stored procedure that is calling several other stored procedure
which update or append values in several tables. All of them are stored
procedures with input parameters by which they filter rows to be updated or
inserted into other tables.
Filtration is based on certain actual values on forms (form with several
subforms).

My question is following: How to pass parameters to those stored procedures
that are triggered by a button?
Those stored procedures are not recordset of forms, so I can't pass it using
Input Parameters property of forms (or I can?).

Thanks.

Zlatko

Jul 20 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Hi

You may be better posting to an Access Newsgroup such as
microsoft.public.access.adp.sqlserver.
Not being an access person I don't know the solution, but I would expect
that you can pass values between forms and therefore use them as parameters
to the stored procedure, I would also suspect that if the form is open you
can still access the field values if referenced correctly.
John

"zlatko" <zl***********@sb.htnet.hr> wrote in message
news:cn**********@ls219.htnet.hr...
I use a stored procedure that is calling several other stored procedure
which update or append values in several tables. All of them are stored
procedures with input parameters by which they filter rows to be updated
or
inserted into other tables.
Filtration is based on certain actual values on forms (form with several
subforms).

My question is following: How to pass parameters to those stored
procedures
that are triggered by a button?
Those stored procedures are not recordset of forms, so I can't pass it
using
Input Parameters property of forms (or I can?).

Thanks.

Zlatko

Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.