Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Calling stored Proc w parameters in 2003 ADP
Message
From
14/01/2008 08:11:51
 
 
To
All
General information
Forum:
Microsoft Office
Category:
Access
Title:
Calling stored Proc w parameters in 2003 ADP
Miscellaneous
Thread ID:
01281538
Message ID:
01281538
Views:
51
In Access Project (.adp) 2003, attached to SQL Server 2005 database, I need to capture two variable values from the current form and call a stored procedure using those two values as parameters. I can call the stored procedure,
Private Sub Command20_Click()
On Error GoTo Err_Command20_Click

    Dim stDocName As String

    stDocName = "sInsertStepIntTestSteps"
    DoCmd.OpenStoredProcedure stDocName, acViewNormal, acEdit

Exit_Command20_Click:
    Exit Sub

Err_Command20_Click:
    MsgBox Err.Description
    Resume Exit_Command20_Click
    
End Sub
but can find no documentation on how to pass the parameters. All help is appreciated.
Thank You

Rollin Burr

Politicians and diapers have one thing in common. They should both be changed regularly, and for the same reason.
Reply
Map
View

Click here to load this message in the networking platform