Additional Useful Functions

Public Sub AlterColValDups(ColIndex As Integer, AlterMask As String)

Replaces all duplicates of a value in a column with a nominated string. The columns must be sorted already if the duplicates are to be in a single contiguous block. The first value is not modified.
This can simulate the 'Hide Duplicates' property available in Access reports.

Public Sub CreateAggregateColFromSecondaryList(PrimaryListIDColNameOrIndex As Variant, PrimaryListAggColNameOrIndex As Variant, SecondaryList As xf_DataList, SecondaryListIDColNameOrIndex As Variant, SecondaryListAggColNameOrIndex As Variant)

Collate related FK values from a second DataList as a delimited list.
See overview for more detailed information.
Two lists are loaded with the main and related tables, taking care that the secondary list is ordered first by the column matching the primary list ID column.
This way the aggregation can be achieved with a single loop of the secondary list, rather than a loop for each row in the primary set.
This function was designed to be a very fast replacement to an otherwise slow SQL operation.

Public Function RowDataEqual(objCompareToList As xf_DataList, Optional ExternalRowIndex As Long = -1, Optional InternalRowIndex As Long = -1, Optional CompareRowCount As Long = -1, Optional LimitToFirstNColumns As Long = -1, Optional ExcludeExtColumnIndexArray As Variant = Null) As Boolean

Is the row data equal in the selected range of this and the external DataList ?