OpenTable Method

Microsoft Access Visual Basic

OpenTable Method

       

The OpenTable method carries out the OpenTable action in Visual Basic.

expression.OpenTable(TableName, View, DataMode)

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

TableName  Required 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  Optional AcView.

AcView can be one of these AcView constants.
acViewDesign
acViewNormal default. Opens the table in Datasheet view.
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.

If you specify the datamode argument and leave the view argument blank, you must include the view argument's comma. If you leave a trailing argument blank, don't use a comma following the last argument you specify.

Example

The following example opens the Employees table in Print Preview:

DoCmd.OpenTable "Employees", acViewPreview