DoCmd.OpenQuery Method
| Access Developer Reference |
The OpenQuery method carries out the OpenQuery action in Visual Basic.
Syntax
expression.OpenQuery(QueryName, View, DataMode)
expression A variable that represents a DoCmd object.
Parameters
| Name | Required/Optional | Data Type | Description |
|---|---|---|---|
| QueryName | Required | Variant | A string expression that's the valid name of a query in the current database. If you execute Visual Basic code containing the OpenQuery method in a library database, Microsoft Access looks for the query with this name first in the library database, then in the current database. |
| View | Optional | AcView | A AcView constant that specifies the view in which the query will open. The default value is acViewNormal. |
| DataMode | Optional | AcOpenDataMode | A AcOpenDataMode constant that specifies the data entry mode for the query. The default value is acEdit. |
Remarks
You can use the OpenQuery method to open a select or crosstab query in Datasheet view, Design view, or Print Preview. This action runs an action query. You can also select a data entry mode for the query.
.gif "Bb238028.vs_note(en-us,office.12).gif") Note |
|---|
| This method is only available in the Microsoft Access database environment. See the OpenView or OpenStoredProcedure methods if using the Microsoft Access Project environment (.adp). |
Example
The following example opens Sales Totals Query in Datasheet view and enables the user to view but not to edit or add records:
| Visual Basic for Applications |
|---|
|