It’s faster to enumerate a collection with the For each…Next statetment: Dim c As Class1 For Each c In Col ‘Code… NextDim fldField As ADODB.Field For Each fldField In rsTemp

In pre-standard C++, certain implementations of offered the flags ios::nocreate and ios::noreplace for controlling file creation. These flags were too platform-specific and never made it into the standard library, which

C++ defines the symbolic constants EXIT_SUCCESS and EXIT_FAILURE that you can use as return codes. These macros are defined in the header file ( in C) as follows: #define EXIT_SUCCESS

This is a common source of misunderstanding: a programmer creates a container of pointers, then fills that container with pointers to dynamically allocated objects. When the container is destroyed, the

The C++ Standard requires that the C standard library be declared in namespace std, just as the C++ Standard Library. Thus, if you #include and call printf(), you should use

You can create an array of pointers to member just as you would create arrays of any other type. The following example creates an array of pointers to member functions

You can force scanf() to read only specific characters from the input source while ignoring all the rest. Alternatively, you can force scanf() to read all input characters except the

The Standard Library defines the two template functions std::min() and std::max() in the header. In general, you should use these template functions for calculating the min and max values of

Private Declare Function ExtFloodFill Lib “GDI32” (ByVal hDC As Long, _ ByVal X As Long, ByVal Y As Long, ByVal colorCode As Long, _ ByVal fillType As Long) As LongConst

‘ make a modeless form modal” this procedure should be called by passing TRUE’ in the 2nd argument to make the form modal, and’ called again with FALSE in the

‘ get the index of the active OptionButton in an arrayFunction OptionButtonIndex(optArray As Object) As Integer Dim ctrl As Control ‘ this means not found OptionButtonIndex = -1 For Each

When you plan to create more control of the same type you can save some clicks by selecting the control on the Toolbox with the mouse while you press the

Private Declare Function OleTranslateColor Lib “OLEPRO32.DLL” (ByVal OLE_COLOR _ As Long, ByVal HPALETTE As Long, pccolorref As Long) As Long’ convert a VB color constant to a COLORREF’ accepts both

Private Declare Function GetDesktopWindow Lib “user32” () As LongPrivate Declare Function GetDC Lib “user32” (ByVal hWnd As Long) As LongPrivate Declare Function GetDeviceCaps Lib “gdi32” (ByVal hDC As Long, _

Declare Function SendMessage Lib “user32” Alias “SendMessageA” (ByVal hwnd As _ Long, ByVal wMsg As Long, ByVal wParam As Long, lParam As Any) As LongDeclare Function GetWindowLong Lib “user32” Alias

The Microsoft Multimedia Control lets you easily determine the total playing time of an Audio CD: you only need to correctly initialize the control and then decipher the value returned

The following is a template for building collection class modules in a very quick and effective way. Copy-and-paste this code into Notepad, that save it to a file named “COLLECTION

Private Type RECT Left As Long Top As Long Right As Long Bottom As LongEnd TypePrivate Const SPI_GETWORKAREA = 48Private Declare Function SystemParametersInfo Lib “user32” Alias _ “SystemParametersInfoA” (ByVal uAction

Private Type RECT Left As Long Top As Long Right As Long Bottom As LongEnd TypePrivate Declare Function GetWindowRect Lib “user32” (ByVal hWnd As Long, _ lpRect As RECT) As

Private Const SPI_SETSCREENSAVEACTIVE = 17Private Const SPI_GETSCREENSAVEACTIVE = 16Private Const SPIF_SENDWININICHANGE = &H2Private Const SPIF_UPDATEINIFILE = &H1Private Declare Function SystemParametersInfo Lib “user32” Alias _ “SystemParametersInfoA” (ByVal uAction As Long, ByVal

Private Type RECT Left As Long Top As Long Right As Long Bottom As LongEnd TypePrivate Declare Function GetClientRect Lib “user32” (ByVal hWnd As Long, _ lpRect As RECT) As

Private Const SPI_SETSCREENSAVETIMEOUT = 15Private Const SPI_GETSCREENSAVETIMEOUT = 14Private Const SPIF_SENDWININICHANGE = &H2Private Const SPIF_UPDATEINIFILE = &H1Private Declare Function SystemParametersInfo Lib “user32” Alias _ “SystemParametersInfoA” (ByVal uAction As Long, ByVal

Sometimes, sprintf() is unavoidable. For example, when compatibility with C is paramount, Sprintf() has a safer version called snprintf(), which doesn’t write past its buffer’s limits. However, because snprintf() was

ASSERT is a very helpful macro for debugging, because it helps root out false assumptions. However, many programmers make the mistake of putting actual assignments inside the macro. Consider the

If you want to convert from a const to a nonconst or from a volatile to a nonvolatile, you can use const_cast. This is the only conversion allowed with const_cast.