Problem with using stored procedure with an Access 2002 report

D

Doug

I have a stored procedure that accepts a number of parameters. In the onOpen
event of my report I set the me.recordsource = me.openargs. The me.openArgs
contains the following statement:

exec spApptsByMthTEG @syear = '2004',@iclientcode = 7471

When I execute the report I get Run-time error 5: Provider command for child
rowset does not produce a rowset. It seems to work fine when me.openargs
only has one parameter such as: exec spApptsByMthTEG @syear = '2004'

If I execute the contents of me.openargs in Query Analyzer it works great.

I would really appreciate any help you can give me.

Thanks,
Doug
 

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

Run a SQL Stored Procedure from VBA 0
Report from Stored Proc w/param 4
the stored procedure executed successfully but did not return reco 1
Problems generating reports from a modal dialog 3
Access pass-through query to Oracle 10g stored procedure - results 1
Access Pass-Through To Oracle 10g Stored Procedure - Return Result 1
adp report does not recognize fields from stored procedure 3
Integrating Access report with stored procedure 0

Top