Microsoft Access VBA Programming for the Absolute Beginner

Opens a stored procedure in an Access Data Project.

Syntax

DoCmd.OpenStoredProcedure ProcedureName[, View][, DataMode]

with the following parameters:

ProcedureName

A String defining the name of the stored procedure.

View

One of the following members of the AcView enumeration: acViewDesign (design view), acViewNormal (runs the stored procedure and displays the results, the default), and acViewPreview (opens the stored procedure in print preview).

DataMode

A member of the AcOpenDataMode enumeration for stored procedures opened in acNormal view. Possible values are acAdd, acEdit (the default), and acReadOnly.

Comments

The OpenStoredProcedure method was first introduced in Access 2000.