When working in Windows, it is very easy to lose a minimized icon onthe desktop. Or you may forget you have an application running and tryto open it again from

When updating the values of several records in a loop, put a BeginTrans,CommitTrans around the loop. This will significantly speed up the updateprocess: BeginTrans Do Until dsData.EOF dsData.Edit dsData!sState_cd =

To allow the Enter key to function as a Tab, enter this code in theKeyPress event of your text boxes: Sub Text1_KeyPress (KeyAscii As Integer) If KeyAscii = 13 Then

To select multiple, nonconsecutive rows (a tagged list) in SheridanSoftware’s DataGrid (which is a part of its Data Widgets package), firstset the SelectionTypeRow property of the DataGrid to TagList. For

To create a 3-D text box, place a text box in a 3-D Panel and set thepanel’s AutoSize property to “Autosize Child to Panel.” Thenset the BevelOuter and BevelWidth properties

To add AutoTab to text boxes that have a set MaxLength, add this codeto the text box Change event: Sub Text1_Change () If Len(Text1) = Text1.MaxLength Then SendKeys “{Tab}” End

The latest trend in Windows programs is the use of a 3-D look thatmakes windows and controls appear to be three-dimensional. As a result,a number of tools for adding the

I often see questions in the VBPJ forum about comparative speedsfor different methods of performing actions in code. In many cases, a simplegeneralization of which is fastest cannot be made.

If you work with INI files, save yourself hours of work and downloadthe INIFILE.BAS module I’ve uploaded to the VBPJ and MSBASIC Forumson CompuServe (file KPINI.ZIP). There’s no charge for

There are lots of ways to test for whether a given file exists. Themost common method is to use the Dir$ function. If Dir$ returns a nullstring, then the file

To use a bitmap or other graphics in the client space of MDI forms,the only trick is getting the hWnd for that window so that you can useGDI functions on

When you’re using VB’s built-in database functionality, you’re likelyto get a corrupted database sooner or later. Use this code to open yourdatabases and automatically repair any corrupt ones: On Local

Most professional applications have an Undo menu option under the Editmenu. If you want to have an undo feature for every text box, you may thinkyou need to create a

It is sometimes useful to determine the amount of Windows resourcesavailable. You can show percentage of free resources in an about box, forexample, or to detect memory leaks in a

VB strips comments out in the final .EXE file, so use as many commentsas you need.

Ever wanted to add a “Search for Help on…” item in themenu bar? Here’s the secret: ‘Declares and Constant for Help Menu Declare Function WinHelp% Lib “User” _ (ByVal hWnd%,

Question: Is there a way to target dynamicly created html from a form in one frame to another using perl? Answer: Sure thing.

VB4 not only allows you to create OLE Automation servers, butto debug the server and the calling application simultaneously.If you want to create a remote OLE server, set the Instancingproperty

From the days of VB3, you no doubt recall the pain of retrievinganswers from a dialog form that you displayed from another form.The use of Globals was about the only

Writing add-ins for Visual Basic 4.0 can be challenging, rewarding,and tricky. If you are not careful writing add-ins, you can causeVB to do strange things and even abort. Although I’m

VB4 provides lots of new capabilities to use objects. Unfortunately,all of them require the object to be set beforehand, which isn’talways feasible. VB provides no way to see if an

APILOD16.EXE and APILOD32.EXE access the file WIN32API.TXT toallow the programmer to paste the TYPE declarations needed tocall the Win32 API. The file WIN32API.TXT incorrectly allots a LONG field to eachbit

Because setting the MousePointer property for a form only changesthe shape and does not prevent the application from acceptinguser input from the mouse or keyboard, I have developed this tip.The

Tired of loading icons or bitmaps or creating many images withthe several styles of pictures in form modules that blow up yourapplication and slow it down in VB3? If so,

When I replaced the Apex dbGrid, with the free upgrade, TDBGridS1.OCX,I got complaints about the behavior of the grids when I enteredor edited data in TDBGrid Standard. The cell pointer

Avoid “Couldn’t update; currently locked by user ‘name’ onmachine ‘machine’ ” error in VB4 when two or more applicationsaccess the same MS Access database table. For the given table, a

If you can’t think of anything nice to say about somebody, getto know them better.

When you use some custom controls like QuickPak Professional byCrescent it’s impossible to use the shortcut “Ctrl+V”for “Paste.” “Ctrl+V” allows you to pastetwo times the text of the clipboard. You

When I work with VB under Windows 95, I’ll often do somethingwith a program that causes Windows 95 to be unstable. Normally,I would shut down Windows 95 and restart to

This seemingly undocumented SQL table qualification syntax mightbe useful to access an external table by using the ‘IN’ keyword.I had used this ability before, but kept having trouble with joins(probably