Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Calling stored Proc w parameters in 2003 ADP
Message
De
14/01/2008 08:11:51
 
 
À
Tous
Information générale
Forum:
Microsoft Office
Catégorie:
Access
Titre:
Calling stored Proc w parameters in 2003 ADP
Divers
Thread ID:
01281538
Message ID:
01281538
Vues:
52
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.
Répondre
Fil
Voir

Click here to load this message in the networking platform