devxlogo

Tip Bank

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

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

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.

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

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

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

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

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

Lost Long File Names?

Never, never, never assume that a given API call or control/OCXworks the same under Win95 and Windows NT. For example, the 32-bitfile common dialog handles long file names, right? Well,