Stored Procedure as Report RecordSource

A

A. Schneider

Hallo,
please excuse my bad English.
We are using Access 2000 and MS SQL-Server 7.0.
I have the following problem:
I must use a Stored Procedure with 5 parameters for
RecordSource in a report.
Can I use the following VBA-Code:

Report_Open:
Report_B_Warenausgangsliste.RecordSource = "EXEC
GP_Warenausgang @VersTermin = '" & Forms![F_Warenausgang]!
[vvVersTermin].Value & "'"

Thanks for your help

A. Schneider
 

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

Access Pass-Through To Oracle 10g Stored Procedure - Return Result 1
Creating a querydef of a stored proc on Sql Server 8
sql stored procedure 1
Access ADP Form and Stored Procedure as RecordSource 0
Access ADP Form and Stored Procedure as RecordSource Options 2
Accessing Stored Procedure via VBA 4
Run a SQL Stored Procedure from VBA 0
SQL Server Stored Procedure timeout 3

Top