Tip Bank

Question: I am having to reformat data for addition to a database. My current struggle involves an identification field for certain records. In the new database it needs to be

Question: Is there a 2.5 patch for running on fast computers? Answer: The only patch that I am aware of is the 2.6 patch.

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

When you want to assign a control’s Font to another control, the first obvious way is to assign the Font property directly, as in: Set Text2.Font = Text1.Font but in

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