OpenStoredProcedure Method

Microsoft Access Visual Basic

action in Visual Basic.

expression.OpenStoredProcedure(ProcedureName, View, DataMode)

expression    Required. An expression that returns one of the objects in the Applies To list.

ProcedureName   Required Variant. A string expression that's the valid name of a stored procedure in the current database. If you execute Visual Basic code containing the OpenStoredProcedure method in a library database, Microsoft Access looks for the stored procedure with this name first in the library database, then in the current database.

View   Optional AcView.

AcView can be one of these AcView constants.
acViewDesign
acViewNormal default
acViewPivotChart
acViewPivotTable
acViewPreview

If you leave this argument blank, the default constant (acViewNormal) is assumed.

DataMode   Optional AcOpenDataMode.

AcOpenDataMode can be one of these AcOpenDataMode constants.
acAdd
acEdit default
acReadOnly

If you leave this argument blank, the default constant (acEdit) is assumed.

Remarks

For more information on how the action and its arguments work, see the action topic.

Example

The following example opens the Employees stored procedure in Design view.

DoCmd.OpenStoredProcedure "Employees", 1