SetRange

The SetRange method restricts a table to a date range.

Applies To

All Table objects

Syntax

objAppointmentsTable.SetRange StartDate, EndDate

Parameters

StartDate

Specifies the date on which the restriction starts.

EndDate

Specifies the date on which the restriction ends.

Remarks

If no parameters are passed, previous restrictions are removed. A call to the SetRange method also resets the cursor to the top of the table. The following sample code shows how both dates require an opening and closing # character:

objTable.SetRange #11/16/95#, #11/18/95#

Note This method must be called before using a merged table.

See Also

SetRestriction