Static inner classes are pretty simple in concept and implementation.Basically, you define a static class inside your primary class: public class Foo // …. public static class Test public static
To list the fieldnames of a recordset in runtime, break the code in the procedure after the recordset has been initialized and enter the following lines into the debug window.
Dim rs As New ADODB.Recordset Dim vCount() As Variant Dim lCount As Long rs.Open
Sometimes you have a stored procedure that takes 2 to 5 minutes to execute. Applications that lock up frequently frustrate users and waste their time and resources. The ADO asynchrous
This tip describes how to display the little window that pops up when you press the custom button on the ADODC. You
By default, multiline TextBox controls insert a tab stop position every 8 characters; in other words, if you press the Ctrl+Tab key while the focus is inside a multiline TextBox
Private Declare Function SendMessage Lib “user32” Alias “SendMessageA” (ByVal _ hwnd As Long, ByVal wMsg As Long, ByVal wParam As Long, _ lParam As Any) As LongConst EM_LINEFROMCHAR = &HC9Const
Private Declare Function SendMessage Lib “user32” Alias “SendMessageA” (ByVal _ hwnd As Long, ByVal wMsg As Long, ByVal wParam As Long, _ lParam As Any) As LongConst EM_LINESCROLL = &HB6′
Private Declare Function SendMessage Lib “user32” Alias “SendMessageA” (ByVal _ hwnd As Long, ByVal wMsg As Long, ByVal wParam As Long, _ lParam As Any) As LongConst EM_FMTLINES = &HC8′