The OpenView method carries out the OpenStoredProcedure action in Visual Basic. For more information on how the action and its arguments work, see the action topic.
Syntax
DoCmd.OpenStoredProcedure procedurename [, viewmode] [, datamode]
The OpenStoredProcedure method has the following arguments.
| Argument | Description |
|---|---|
| procedurename | 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. | |
| viewmode | One of the following intrinsic constants: |
| acViewNormal (default) acViewDesign acViewPreview |
|
| If you leave this argument blank, the default constant (acViewNormal) is assumed. | |
| datamode | One of the following intrinsic constants: |
| acAdd acEdit (default) acReadOnly |
|
| If you leave this argument blank, the default constant (acEdit) is assumed. |