Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
blinton25
Yak Posting Veteran
90 Posts |
 Posted - 2004-04-01 : 16:54:39
|
| Hello,How are you today?I have a report which takes calls a union query which has two parameters. In Access these parameters come from a form (forms!etc). However I upsized the query to a stored procedure, and planned to call it using a SQL Pass Through Query. Of course the parameters won't work in a pass through query, so how do I pass the parameters to the stored procedure? |
|
|
blinton25
Yak Posting Veteran
90 Posts |
Posted - 2004-04-02 : 17:19:37
|
| Hello,Found a way to do this:http://p2p.wrox.com/topic.asp?TOPIC_ID=5485which works from the Immediate Window. Not sure how to call the module from the report in order to obtain the resultset, any idea? |
 |
|
|
|
|
|
Pass Parameters to Stored Procedure from Access