Compiled ADP getting return value from SQL Stored Procedure

G

Guy Kerr

I've seen all sorts of messages about using ADO to get a return value from a
stored procedure but I'm using Visual Studio Tools for MsOffice which allows
me to define the connection information and not have to worry about that in
my code. I simply use the following code to call the stored procedure with a
parameter:
SQLStmt = "Exec dbo.spCRS_GetCrsNumber " & Me.DebtorID
DoCmd.RunSQL SQLStmt

That being said, I'm racking my brain trying to understand if/how I can get
a return value from a stored procedure using this coding method. Does anyone
have any examples they can provide me to get me over the hump?

Thanks in advance
 
B

Brendan Reynolds

I believe that the answer is no, you can't do it using DoCmd.RunSQL. It can
be done using ADO, but I gather you already know about that. If you need any
help doing it with ADO, see the ADP newsgroup, if I remember correctly I
think it was discussed there quite recently.
 

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

Using Access ADP to get return value from a SQL stored procedure 1
Run a SQL Stored Procedure from VBA 0
getting return value from stored proc 4
Return Values from SQL Server to MS Access 1
sql stored procedure 1
Need help with ADP- Stored procedure using select query and criteria 0
Integrating Access report with stored procedure 0
Data return from SQL Stored procedure... 0

Top