Don’t forget to turn off the .sorted property on the combo box before calling! ResortCboFromAlphaToNum cboAbcPublic Sub ResortCboFromAlphaToNum(cc As ComboBox) ‘resorts given combobox from alpha sort (usual) to numeric sort

Sometimes you want to initialize arrays with values, but you can’t because you’d have to provide values explicitly. There is a way to generate these kinds of assignment statements.Say you

This is useful in gathering the title information of the forms for your program or other programs. You retrieve the information and display it for your user or use it

You should lock controls (that have the .locked property) rather than setting .enabled = false.Why? Grey text in a disabled field is less readable. Also, blank fields give no indication

Option Explicit’ This structure holds Bitmap informationPrivate Type BITMAP bmType As Long bmWidth As Long bmHeight As Long bmWidthBytes As Long bmPlanes As Integer bmBitsPixel As Integer bmBits As LongEnd

‘ This structure holds Bitmap informationPrivate Type BITMAP bmType As Long bmWidth As Long bmHeight As Long bmWidthBytes As Long bmPlanes As Integer bmBitsPixel As Integer bmBits As LongEnd Type’

‘ Draw a polygon, given its center and number of sides’ CTRL can be either a form or a PictureBox control.’ ANGLE is an optional angle in degreesSub DrawPolygon(ctrl As

‘ This structure holds Bitmap informationPrivate Type BITMAP bmType As Long bmWidth As Long bmHeight As Long bmWidthBytes As Long bmPlanes As Integer bmBitsPixel As Integer bmBits As LongEnd TypePrivate

‘ This structure holds Bitmap informationPrivate Type BITMAP bmType As Long bmWidth As Long bmHeight As Long bmWidthBytes As Long bmPlanes As Integer bmBitsPixel As Integer bmBits As LongEnd Type’

‘ This structure holds Bitmap informationPrivate Type BITMAP bmType As Long bmWidth As Long bmHeight As Long bmWidthBytes As Long bmPlanes As Integer bmBitsPixel As Integer bmBits As LongEnd Type’

Many tip & trick collections report that you can learn if the contents of a text box has been modified by sending a EM_GETMODIFY message to the control. Actually, getting

Using script caching when a script is extremely large or embedded across multiple pages can improve the performance of code in JavaScript. It also allows you to easily distribute one

There are CSS attributes responsible for controlling the scrollbar’s coloring, everything from the background, foreground, to the little arrow at the two ends of the scrollbar. –Your Normal code goes

If all you need to know is whether a table is empty, using COUNT(*) is a bad alternative, because if the table is very large, it will take some time

In the SQL Server 7 days, when we wanted to calculate data and return it, we usually used stored procedures. User-defined functions are a new feature of SQL Server and

One of the problems that Web developers face today is: ‘How can I store the usernames of my visitors in a SQL Server database if each language has it’s own

Overriding a method suppresses the visibility of any overloads in the base class for the overridden method. Say you have a base class CBase where there are two trivial overloads:

As in C and C++, it is not easy to give input to an application in Java. This is sample code to check whether the given number is even or

This code will allow you to launch a file with its associated program. #If Win32 ThenDeclare Function ShellExecute Lib “shell32.dll” Alias “ShellExecuteA” _(ByVal hwnd As Long, ByVal lpOperation As String,

Since Crystal Reports files are stored in a binary format, it’s impossible to accurately track (using SourceSafe, for example) the changes you and your colleagues make.To help remedy this situation

First of all, create a string array with the elements of a browser exe path and the file you desire to open in your browser. Next, create an instance of

How do you use the LogonUser API in VB?1. Call RevertToSelf (this is the critical step as it allows the code torun under the System account)2. Call LogonUser3. Call ImpersonateUserThis

In a few cases, in particular when running MsDos batch files from within a VB application, you may want to determine the ERRORLEVEL set by an external application. You can’t

There is no built-in VB function that lets you know whether a control – such as a ListBox – is currently displaying a vertical scrollbar. Here’s a pair of functions

Before posting an Internet request you should check that the user has entered a valid Internet address. You can do this with a parsing routine, or use the following routine

Frequently you need to sort arrays of records using multiple keys. This may be required since one single key does not uniquely identify a record (e.g. you may need both

The GlobalMemoryStatus API function returns detailed information about the current load on the physical and virtual memory. You can use the following code to display the current amount of free