Tip Bank

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 –

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 =

One of the most effective optimization techniques consists of caching data inside Application or Session variables. However, you should pay attention to how you reference to the elements in those

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

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

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

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,

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