When you need a timer for a larger interval than the Timer control allows, insert this code into a BAS module. The procedure starts when the timer interval has passed:

Dynamic Color Change of TextHello Good Morning

When you

If you have dynamically generated form controls on a Web page, all with the same name, this is a good way to parse out each control’s value and load them

Here

The Option button is a convenient way to display multiple options from which only one can be selected. One problem is that the Option button cannot be bound to a

Many professional applications are required to display a version number on all screens to indicate to users which version of the app is currently running. This also helps with configuration

‘ Saves a text file. If the destination file already exists,’ its content can be replaced, or the new content can be appended’ at the end of the file, according

‘ Returns the content of the specified text file’ Note: it can throw an exception’ Usage: Dim FileContent As String = LoadTextFile(“C:Autoexec.bat”)Function LoadTextFile(ByVal FilePath As String) As String Dim sr

‘ Copies a source directory to the destination directory.’ The last parameter specifies whether the files already present in the’ destination directory will be overwritten’ – Note: requires Imports System.IO’

‘ Returns the size of the specified directory’ – Note: requires Imports System.IO’ – Usage: Dim DirSize As Long = GetDirectorySize(“D:Projects”)Function GetDirectorySize(ByVal DirPath As String) As Long Dim DirSize As

‘ Open the standard dialog to download a file located on the server’ whose virtual path is passed as an argument. This routine is useful when’ you want to download

You can use the name of a Function or Property Get procedure as a local variable anywhere in the procedure. If your procedure returns a String or UDT type, writing

You can stop a program

To determine whether a control is a member of a control array, you can reference its Index property and handle the generated error when the control is not in an

When the user presses Cancel on a VB InputBox, the string returned is a vbNullString. If the user inputs a zero-length string and presses OK, the return string is empty

The CheckBox control in VB supports three positions: Checked, Unchecked, and Grayed. Unfortunately, the default behavior for the control is to cycle between Checked and Unchecked. To set it to

This is a simple tip that proves useful in the long run. Consider the following example: void someFunction() {Date d= new Date(); // The Date object is created outside the

To insert data with single quotes, place 2 single quotes instead of 1 single quote, like this: create table MyTable ( Field1 varchar(10))goinsert MyTable (Field1) select ‘A1111”1111’ UNION ALL select

This method allows you to insert multi-lingual characters into an Oracle database. In this tip, the column type is varchar2. The multi-lingual string is converted to its unicode value and

This code can also be used to navigate through the Resultset backward or forward, or to perform insertions, deletions and updates to update the database. //load JDBC Driver// Get the

JavaScript does not offer Left and Right functions. Use the following functions to extract the left or the right part of a string. function Left(str, n){ if (n String(str).length) return

This tip explains how to pass an object to a JavaScript function and retrieve the values from the “this” object. See the following piece of code: click… Run the above

‘ Returns a formatted string that shows the size in Bytes, KBytes or MBytes’ according to the size’ Usage:’ Dim ProperSizeString As String = FormatSize(“132100842”)’ -> returns “125.98 MB”Function FormatSize(ByVal