Re: MSAccess Stored Procedure Call with an OUT parameter

In article <nCm7b.9$e85.3359_at_se2-cb104-9.zrh1.ch.colt.net>, MSchoebi_at_gmx.ch says...
> Hello,
>
> How can I call from MSAccess a stored procedure with an OUT parameter?
> So the I get The OutParameter in MS Access as a variable?
>

If you're using ADO, it's gonna look something like this:

Dim conn As New ADODB.Connection
Dim cmd As New ADODB.Command

conn.Open "blah-blah-blah"         

With cmd

  .CommandText = "MY_STORED_PROC"
  .CommandType = adCmdStoredProc
  .ActiveConnection = conn
  .Parameters.Append .CreateParameter(, adInteger, adParamInput, , 100)
  .Parameters.Append .CreateParameter(, adInteger, adParamOutput)
  .Execute
  Set .ActiveConnection = Nothing
            

  MsgBox "OUT Parameter is: " & .Parameters(1).Value End With

• Tom