The Slider control has a capability that you might ignore: you can assign its SelectRange property to True to enter Select Range mode, during which the user can use the
When you use a COM or COM+ from a .NET application and then you set the object reference to Nothing (or let it go out of scope), the object isn’t
‘ get the IE installation path, or a null string if it isn’t installed” NOTE: requires the GetRegistryValue routineFunction InternetExplorerPath() As String Const HKEY_LOCAL_MACHINE = &H80000002 ‘ get the path
If you have defined a default document for a given IIS virtual directory, any link pointing to the directory will actually point to the default document for that directory. However,
At times you may need to verify that the VB IDE is the current process. This is necessary, for example, when you are notified that the user has presses a
Private Declare Function SystemParametersInfo Lib “user32” Alias _ “SystemParametersInfoA” (ByVal uAction As Long, ByVal uParam As Long, _ ByRef lpvParam As Any, ByVal fuWinIni As Long) As LongConst SPI_SETDESKWALLPAPER =
‘Check if the specified OLEDB Provider is installed and registered correctly”Example: check the Jet 4.0 OLEDB Provider’MsgBox “The specified OLEDB provider ” & ‘ IIf(CheckOLEDBProvider’ (“Microsoft.Jet.OLEDB.4.0”), “does”, “does not”) &
The SQL language includes the SUM() aggregate function, that evaluates the sum of all the values in a given column, but it doesn’t include a PROD() function that evaluates the
At times you may need to swap the values of two columns of the same SQL Server table. For example, suppose that you realized that the fname column of the