devxlogo

Tip Bank

Returning Recordsets From COM Components

Question: I have heard from some that it is a bad idea to return recordsets from COM components and that you should populate a variant array and send that back

Creating a For/Next Loop

Question: I tried using the replace function as shown below, but I receive an error on using “Next i”. Function formatOutput( theText )Dim iDim sNewStringFor i = 1 to Len(theText)

Filtering Recordset Data

Question: After retrieving data into a recordset object, I want to filter this data. I tried using the objRs.filter method of ADO, but it doesn’t seem to work. This is