Tip Bank

DevX - Software Development Resource

Close VB Before Compiling

When you’re finished tinkering with your apps, close and restart VBbefore making the final EXE. This simple action can reduce the size ofyour EXE by 10 to 30 percent (many

DevX - Software Development Resource

Does an Object Have a Value?

You cannot use the IsEmpty function to determine if a variableof type Form or any Object has been assigned a value. You can,however, use this method to determine if the

DevX - Software Development Resource

Load a VB4 Form in VB3

You cannot load a VB4 form in VB3 directly. You must modify theform definition. When you open a VB4 form, the file will resemblethe example: VERSION 4.00Begin VB.Form Form1 Caption

DevX - Software Development Resource

Create A Controlled DoEvents

I needed a way to issue a DoEvents to allow Windows time to redraw controlson a form, but wanted to prevent the user from clicking some other controlwithin my application.

DevX - Software Development Resource

Converting Identifiers into Labels and Column Headings

Programmers are in the habit of creating meaningful identifiersby concatenating the words of a “title case” phrasethat describes the identifier, such as LastName or FinalPaymentDate.Often, you can use these names

DevX - Software Development Resource

Selecting The Text When Entering A Field

In many cases, it is best to select or highlight the full text of afield when that field gains the focus. This allows the user to simply begintyping to replace

DevX - Software Development Resource

Correctly Convert SQL Server Floats By Jet

When using the SQL Server ODBC driver and SQL Server, and If ODBC preparedexecution is used, certain floating-point values may be incorrectly converted.Microsoft Access and Microsoft Visual Basic commonly use

DevX - Software Development Resource

File Exists?

One way to test whether a specific file exists is to open thefile for input and check VB’s error flag. An error will occurif the file does not exist. Use

DevX - Software Development Resource

Successfully Close ODBC Connections

The Microsoft Access engine will maintain a persistent connection onan ODBC connection in order to be more efficient, even after using a Closemethod on a database opened with ODBC. The