Pair.DBOptions Property

<< Click to Display Table of Contents >>

Navigation:  Developer Edition > Visual Basic for Applications (VBA) > Object Model Reference > Pair Object > Properties >

Pair.DBOptions Property

Previous pageReturn to chapter overviewNext page

Returns or sets options for sorting or grouping database records. DBOptionFlag value.

 

Syntax

expression.DBOptions

expression. A variable representing a Pair object.

 

Example

This example groups the records.

 

With oProj.Pairs.Item(0)

   'row number of database heading

   .DBRow = 3

   'create primary key; column no. of source file

   .DBKeys = "2;3"

   'group records

   .DBoptions = DBOptionFlag_Group

End With