Using Access ADP to get return value from a SQL stored procedure

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've seen posts showing how to get a return value from a stored procedure but
I'm using Visual Studio Tools for MsOffice which allows me to simply set the
connection information and I don't need to provide it when calling a stored
procedure. I use something similar to the code below:

SQLStmt = "Exec dbo.spCRS_GetCrsNumber " & Me.DebtorID
DoCmd.RunSQL SQLStmt

Can someone please point me in the right direction to help me figure the
correct syntax to get a return value from a stored procedure?

Thanks in advance
 
Answered in another thread in this newsgroup (subject 'Compiled ADP getting
return value from SQL Stored Procedure').
 

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

Compiled ADP getting return value from SQL Stored Procedure 1
Invalid Column Name Sql-Error :Executing a stored procedure 1
Call stored procedure in SSMS from Access 2016 doesn't work. 0
Access 2002 .adp subform linking using stored procedures 1
Return Values from SQL Server to MS Access 1
Get Value 2
getting return value from stored proc 4
Posting a dataset to a SQL table using VBA 0

Back
Top