Use the EXECUTE statement to execute the stored procedure : Stored Procedure « Access « VBA / Excel / Access / Word

Home
VBA / Excel / Access / Word
1.Access
2.Application
3.Data Type
4.Data Type Functions
5.Date Functions
6.Excel
7.File Path
8.Forms
9.Language Basics
10.Math Functions
11.Outlook
12.PowerPoint
13.String Functions
14.Windows API
15.Word
16.XML
Microsoft Office PowerPoint 2007 Tutorial
Microsoft Office Excel 2007 Tutorial
Microsoft Office Word 2007 Tutorial
VBA / Excel / Access / Word » Access » Stored Procedure 
Use the EXECUTE statement to execute the stored procedure
 
Sub CreateStoredProc()
    Dim cmd As ADODB.Command
    Set cmd = New ADODB.Command

    cmd.ActiveConnection = CurrentProject.Connection
    cmd.CommandText = "CREATE PROCEDURE procClientGet " & _
        "(CID long) " & _
        "AS SELECT ClientID, CompanyName " & _
        "FROM tblClients " & _
        "WHERE ClientID = CID"
    cmd.Execute
End Sub

Sub ExecuteStoredProc()
    Dim rst As ADODB.Recordset
    Dim cmd As Command
    Set cmd = New ADODB.Command

    cmd.ActiveConnection = CurrentProject.Connection
    cmd.CommandText = "EXECUTE procClientGet 1"
    Set rst = cmd.Execute
    MsgBox rst("CompanyName")
End Sub

 
Related examples in the same category
1.Create a stored procedure
2.Call store procedure
3.Creating a Stored Procedure that Accepts Parameters
4.Executing a Parameterized Stored Procedure
5.Deleting a Stored Procedure
6.Executing a Stored Procedure Containing Parameters
java2s.com  |  | Contact Us | Privacy Policy
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.