Dim rs As New ADODB.Recordset Dim vCount() As Variant Dim lCount As Long rs.Open Related Posts Detroit Debuts Wireless EV Charging RoadsHow To Transfer Photos From Android To ComputerRetrieving Data

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.

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 Related Posts Making a Java List Thread SafeQuick

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_LINEINDEX = &HBBConst

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′

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′

Setting a multiline TextBox’s SelStart property doesn’t ensure that the insertion point (the caret) is visible. You can achieve this by sending the control an appropriate message: Private Declare Function

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

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

The Object.hashCode() method returns a number that is effectively random. This number is also implementation- and instance-dependent. This has a couple consequences: 1 – The order of iteration for elements

The environment of a SQL plus session, like linesize, pagesize, etc., can be permanently set according to one’s own needs with the help of login.sql file. The settings can be

The Collections class provides static APIs to generate a read-only or unmodifiable collection, list, set, or map from the specified entity. For instance, if you are sure that the ArrayList

As you know by now, the commonly used collection classes, such as java.util.ArrayList, are not synchronized. However, if there’s a chance that two threads could be altering a collection concurrently,

The C preprocessor provides for conditional compilation in instances where large areas of text are ignored and stripped out, regardless of whether a given preprocessor constant was defined. For example:

The size of the database is the total size of the datafiles that make up the tablespaces of the database. These details are found in the dba_extents view. Type the

Suppose you want to pass an object to a method and also want to allocate the object into that method. If you pass the object as it is, it will

Using the DTPicker control is good except if you Related Posts Airwallex Eyes Explosive Latin American GrowthJames Webb telescope uncovers early black holesUse the Preload Resource Hint for Super-fast CSSBiden

Fields defined in interfaces are automatically public, static, and final. Being final, they cannot be Related Posts Batagay megaslump reveals ancient permafrost layersCircle to Search hints at potential upgradesReport: Apple

When writing an ATL DLL or an ActiveX Control DLL, developers used to take off the ATL_MIN_CRT. However, this action will increase the size of the DLL up to almost

If one is not careful with implicit typecasting, one can get very weird results that are not easy to detect.Look at the code below: int number;.. //some computation and codeint

Add the following procedure to your collection object: Public Function Item(ByVal Value as Variant) _as SomeObject Set Item = mCollection.Item(Value) ‘mCollection is your private module level ‘collection object.End Function Now,

It’s important to remember that you may want to use your classes in future projects. Overtime class files may change directories, or your next program could be for use on

If there are no calls to constructors in the initialization list, an implicit copy constructor of a derived class always calls the copy constructors of the base classes. On the

Function FormatProper(ByVal strName As String) As String’**********************************************************************’* Take any name string and return it in proper capitalization’********************************************************************** Dim strProperName As String Dim varProperName As Variant Dim intCount As Integer Dim

You can easily add animation when showing or hiding a window using the AnimateWindow API. There are three types of animation: roll, slide, and alpha-blended fade. The declaration of API

There are a few reasons why one would see this error, but the most common is in the ordering of the MFC header files. Over time, Microsoft has weeded out