DoCmd.OpenTable Method (Access)
The OpenTable method carries out the OpenTable action in Visual Basic.
Syntax
식 .OpenTable(TableName, View, DataMode)
식 A variable that represents a DoCmd object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
---|---|---|---|
TableName |
필수 |
Variant |
A string expression that's the valid name of a table in the current database. If you execute Visual Basic code containing the OpenTable method in a library database, Microsoft Access looks for the table with this name first in the library database, then in the current database. |
View |
선택 |
AcView |
A AcView constant that specifies the view in which the table will open. The default value is acViewNormal. |
DataMode |
선택 |
AcOpenDataMode |
A AcOpenDataMode constant that specifies the data entry mode for the table. The default value is acEdit. |
Remarks
You can use the OpenTable method to open a table in Datasheet view, Design view, or Print Preview. You can also select a data entry mode for the table.
Example
The following example opens the Employees table in Print Preview:
DoCmd.OpenTable "Employees", acViewPreview