Question: How do I check strings that have only alphanumeric characters? Answer: When you say alphanumeric, I assume you mean that the characters are in one of the following domains:
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,