I have created a generic function for changing the key for an object in a collection: ‘Module: Module1 Option Explicit Public Function ChangeKey(Object As Object, NewKey As String, Collection As
If you are loading Multiple ComboBoxes or ListBoxes from the same recordset, a fast way to do this is to only loop the recordset once.Here is a generic function that
The fastest way to clear a collection is just to set the variable to a new Collection object. However, if it’s necessary to free the references the collection is keeping,
You cannot make a separate location to assign one object to another. By implementing a Cloneable interface and calling the clone() method, you can make a separate location for the
This code will return the date of the next weekday that you specify.For example, assuming today is July 4th, 2001 and you need to know the date for next Monday,
SQL Server, and the SQL language in general, doesn’t support record numbers, so you can’t extract a set of records if you know their position in the resultset. This missing
CountSort is yet another sort algorithm, which can be applied only under very particular conditions but that, when such conditions are met, turns to be the fastest of the lot.
‘ Retrieve the number of bytes by all the files in a directory’ (it doesn’t account for slack space, that is unused space in disk sectors)” If INCLUDESUBDIRS is true,
Private Declare Function RealizePalette Lib “gdi32″ (ByVal hdc As Long) As Long’ Paint a circular gradient” STARTCOLOR is the starting color (applied to the corner)’ ENDCOLOR is the ending color