ODSOFilters.Add Method

Definition

Adds a new filter to the ODSOFilters collection.

public void Add (string Column, Microsoft.Office.Core.MsoFilterComparison Comparison, Microsoft.Office.Core.MsoFilterConjunction Conjunction, string bstrCompareTo = "", bool DeferUpdate = false);
abstract member Add : string * Microsoft.Office.Core.MsoFilterComparison * Microsoft.Office.Core.MsoFilterConjunction * string * bool -> unit
Public Sub Add (Column As String, Comparison As MsoFilterComparison, Conjunction As MsoFilterConjunction, Optional bstrCompareTo As String = "", Optional DeferUpdate As Boolean = false)

Parameters

Column
String

Required String. The name of the table in the data source.

Comparison
MsoFilterComparison

Required MsoFilterComparison. How the data in the table is filtered.

Conjunction
MsoFilterConjunction

Required MsoFilterConjunction. Determines how this filter relates to other filters in the ODSOFilters object.

bstrCompareTo
String

Optional String. If the Comparison argument is something other than msoFilterComparisonIsBlank or msoFilterComparisonIsNotBlank, a string to which the data in the table is compared.

DeferUpdate
Boolean

Optional Boolean. Default value is False.

Applies to