The IIf function-which returns one of two values determined by logical test-has this syntax: IIf(Expression, TruePart, FalsePart). At first, it might seem like an ideal shortcut for an If…Else…End If

To create a collection class you can use with the For Each…Next syntax, add a subroutine that looks like this: Private myCollection As CollectionPublic Property Get NewEnum() As IUnknown Set

You can easily customize the fonts and colors in individual statusbar panels using a PictureBox control and an API call. Each statusbar panel can display a Picture object, so you

Many routines use the SetWindowPos API to always keep a form on top. Most require the user to remember several nonintuitive arguments. I’ll not only show you how to simplify

It’s often faster to perform string operations with byte arrays than with 32-bit VB’s native double-byte character strings. Even when using 16-bit VB4’s single-byte character strings, it’s still often faster

The Media Control Interface (MCI) can easily support multiple CD audio devices.You simply specify the drive letter in the MCI open command. To eject the CD from any drive,first place

I have read many tips about using MouseMove events to create an Explorer-like coolbar look. The problem is that if your button is located close to the main form’s border

VB provides an easy way to access the Registry with the built-in GetSetting and SaveSetting functions. These functions read and write information to the HKEY_CURRENT_USERSoftwareVB and VBA Program area of

Call this sub to insert text of any color at the current insert point of a RichTextBox: Private Sub ColorText(rtb As RichTextBox, Color _ As Long, Text As String) Dim

VB6’s Setup Wizard generates gradient blue background screens, as do wizards in previous versions of VB. However, an undocumented setting gives you the opportunity to see installation programs with other

I keep all my projects in a particular directory such as C:work. When I save or open up a new project, I want the File dialog box to start at

Windows doesn’t treat comments in INI files the same way VB does in code. Typically, comments must be on a single line of their own. When calling the GetPrivateProfileString function,

If you use variable-length strings and/or dynamic arrays in a user-defined type (UDT), the actual data does not become part of the structure. Instead, four-byte pointers are stored in the

To blank out the text in a masked edit box, make sure the string you assign uses underscores matching the mask. It’s difficult to maintain code when you have to

Examine this code snippet. Will your compiler accept it? void a_func_returning_void();void func(){ return a_func_returning_void(); //returning a value from a void function?} At present, most compilers will not accept this code

The following link ranks several popular C++ compilers according to their ANSI/ISO compliance level. The comparison chart contains various features such as exported templates, Runtime Type Information, Koenig lookup, explicit

Dev-C++ is a free graphical C++ compiler for Windows 95, 98 and NT. You can download it for free from: http://www.bloodshed.net/devcpp.htmlThe Dev-C++ package also includes a debugger and source file

The GNU project focuses on the development and distribution of open source software, including free compilers. The newly-released GCC 2.95 is a free C/C++ compiler. GCC 2.95 includes nearly a

The C++ exception handling model is non-resumptive. In a resumptive model, after an exception has been handled, the program continues execution at the point where the exception was thrown. In

When you create a borderless form in VB (BorderStyle = 0) and make it visible to the taskbar (ShowInTaskbar = True), only the form’s caption shows and the form’s icon

Here are a couple useful Registry edits to enhance your day-to-day Visual Basic development. Save these Registry lines to a text file with a REG extension, and then double-click on

You might have noticed that if you click on a TabStrip tab, then move the mouse pointer until it’s no longer over the TabStrip without releasing the mouse button, the

Use this small API from the shlwapi (Shell Windowing API) DLL that ships with Internet Explorer (IE) to help you convert file size in bytes into proper strings such as

You can easily share files such as standard code, form, and class modules (BAS, FRM, and CLS files, respectively) between VB and VBA by using the appropriate menu commands. Within

Question: How can I register a DLL that I created with Visual Basic 6 on a remote Windows NT 4.0 server? Answer: You will need to install the DLL on

Question: I created a Web page that uses ASP to access a database on the server and return data to a client browser. While the data is accessed the client

Question: I have a column in SQL Server created like this: “vchrFirstName varchar (50) NULL” However, this code does not produce anything, including any errors, when the record is NULL:

Question: How can I prevent sending the contents of a form field containing single quotes to the server? Single quotes should be converted to double quotes in a way that

Two VBScript built in features are disabled when you are using VBScript on the server with ASP. Because ASP scripts are executed on the server, the VBScript statements, InputBox and