can someone briefly explain the use of NOT and IS Nothing in the following line:

 If Not Ds.Tables(strTable_CreditBalanceListingReport) Is Nothing

The "Nothing" keyword indicates a variable is that isn't initialized or doesn't contain valid data.

The "Not" keyword reverses this.

So the line you indicated says that if the dataset table is initialized and valid, then execute the code between the "If" statement.