Compiled ADP getting return value from SQL Stored Procedure

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

Guest

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
 
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.
 
Back
Top