January 1, 2003

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,

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

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 =

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

‘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”) &

Printing is one of the things that you can’t do directly from withing ASP: to have a printout of your data from ASP you must instantiate a COM component –

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

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