stored procedure as RecordSource

W

Wm

Ref: Access 2k, SQL 2k

I can use a stored procedure for the RecordSource to a report. That's easy,
I just choose it from the list offered in design view. I can set the input
parameters in design view also, but how do I do that from VBA?

Thanks!
William
 
M

Mark Andrews

Basically you need to build the query sql for the pass-thru query in access
and save it before running the report.
 

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

"unique" report data 2
Passing variables to stored procedure source 3
Access ADP Form and Stored Procedure as RecordSource Options 2
Call stored procedure in SSMS from Access 2016 doesn't work. 0
Accessing Stored Procedure via VBA 5
Invalid Column Name Sql-Error :Executing a stored procedure 1
printer columns 3
Form recordsource parameter sp change 2

Top