Tip Bank

Question: How do I control the output format for the list structure command so that it always fits on a page (portrait or landscape)? Is there another way to get

The String$ function can replicate only 1-char strings, so it seems that you need a loop to duplicate strings that contain 2 or more characters. However, this is a one-liner

ADO 2.1 added a new, important dynamic property to the Field object, the OPTIMIZE property. If you have a client-side Recordset and you set this property to True, ADO will

It seems that you need two nested For loops to iterate over all the elements of a 2-dimensional array, and three loops for a 3-dimensional array, and so on. However,

As you probably know, the “&” operator is rather slow, especially with long strings. When you have to repeatedly append chucks of characters to the same variable, you can speed

As explained in another item in this Tip Bank, you can use the Recordset’s GetString method to export a Recordset to a comma-delimited or tab-delimited text file. However, if you

‘ Filter out all invalid characters in a string.Function FilterString(text As String, ValidChars As String) As String Dim i As Long, result As String For i = 1 To Len(text)

Reading and writing an item of an array is always slower than accessing a simple variable. Therefore, if you need to repeatedly use the same array item in a loop,

The GetString method of the Recordset object returns a formatted string that contains all the values in each field and each row in the recordset, with your choice of column