You can often use Choose to replace an array and build tables of results evaluated at compile-time instead ofrun time. For instance, if you need to evaluate the factorial of

You can often replace an If…Then…Else block with a more compact IIf function: ‘ returns the max of two valuesmaxValue = IIf(first >= second, _ first, second) Switch is a

When building an ActiveX control, you can set a default property or method using the Procedure Attributesdialog box, after clicking on the Advanced button. However, if your default property also

If you, like me, often used the “array” name for variables, you must revise your code when porting yourapplications to Visual Basic 5.0. This name has become a reserved keyword

Users often find it faster to retype the entire contents of a text box rather than position the cursor within the data, and then edit the data. This is especially

You can write a single procedure that accepts any type of array as an argument by using a variantparameter. Within the procedure, address the array using the usual syntax: ‘

When I write text in message boxes, labels, and so on, and I need to include a carriage return/line feed, I use this function, passing it the number of CR/LFs

THE ADDRESS OF A VARIABLEVB5 includes a built-in VarPtr function (see tip “Use the Object Browser to Discover UndocumentedFeatures”), but this function isn’t available in VB4. The VB4 runtime library

Traditionally, VB programmers benchmark their code using the Timer function. However, if your processmight terminate on the following day, you must take into account that the value returned by that

Unlike VB4, VB5””””s App.Path property might return a UNC path, such as “\serverprograms…”), undercertain circumstances, depending on how the program started and if it””””s interpreted in the VB IDE orcompiled

If you right-click on the right-most pane of the Object Browser, you can issue the Show Hidden Members command. From this point on, the Object Browser shows all hidden properties

If you build an ActiveX control that exposes an enumerated property, you should define a Public Enumstructure that gathers all the possible values for that property. Doing this helps the

If you create out-of-process OLE servers, Visual Basic embeds the companion type library into the EXE fileand generates no TLB file. However, if you own the Enterprise Edition of VB4

The implementation of Public variables in forms and classes changed with Visual Basic 5.0. VB4 implementspublic variables in forms and class modules as if they’re regular variables, using pointers to

When working with multiple projects, it’s easy to get confused by the many windows active on the screen atthe same time. However, you can temporarily hide all the windows related

Here are a few simple ways you can customize your VB5 IDE: Add tabs to the custom control toolbox by right-clicking on the General button and selecting the Add Tab

Unlike templates in other Office 97 products, Word 97 templates provide a business-application engine thatremains separate from the documents that use that engine. Template-based Excel workbooks andPowerPoint presentations include a

A popular code snippet lets you center any form on the screen, regardless of the current screen resolution. You now can reach the same result by simply assigning the value

Never pass a global variable as an argument to a procedure that also accesses the variable directly. If you’re 100 percent sure you adhered to this rule within your application,

If you ever programmed under VB4, you probably took advantage of the powerful Optional parameters. VB5 enhanced them in several ways: they can be of any type now (not only

If you take a look at VB’s native code optimization options for the first time, you might be tempted to click on “Optimize for Fast Code” right away. Strange as

Visual Basic 5.0 lets you comment a block of code in a snap and uncomment it later. This feature is useful in the debug phase, when you don’t want to

Two problems can arise when a confused user scrolls up or down with the mouse and then makes a selection with the Enter Key. First, the down arrow fires two

Question: How can I create texture maps (for 3D objects) that don’t get distorted by the geometry? Answer: Use 3D Paint tools. When I want to paint something in the

Question: What’s happening with Caligari and its VRML tools (trueSpace, VRML, Pioneer, etc.)? Answer: Caligari has rethought its approach to VRML and has integrated the features you may have seen

Question: What are the alternatives to VRML? Answer: There are a variety of proprietary alternatives to VRML available for use over the Internet. Perhaps the best known at the moment

Question: What is this “second Web” I keep hearing about? Is it marketing hype, or a new technology? Answer: It’s a mixture of the two. Perhaps inspired (or provoked) by

Question: How can I create a Sybase login from a PowerBuilder front-end application using sp_addlogin? The normal way of executing stored procedures ? for example, declare procname for procedure ?

Question: How can we distribute the PB deployment kit (Upgrade version) to our remote end-users? Also, do we have to distribute any drivers for Oracle, or can they reside on

Question: I understand that it is possible to print reports stored in a backend Access .mdb file from Visual Basic. Is it possible, and if so, how is it done?