About the Enhanced Data Form

Online Data Entry Jobs

Online Data Entry Jobs

Get Instant Access

The Enhanced Data Form features the following enhancements, as listed in Table 15-1.

Table 15-1 COMPARING THE ENHANCED DATA FORM WITH THE EXCEL DATA FORM

Enhanced Data Form

Handles any number of records and fields.

Dialog box can be displayed in any size that you like.

Fields can consist of either Text Box or ComboBox controls.

Record displayed in the dialog box is always visible onscreen and is highlighted so you know exactly where you are.

At startup, the dialog box always displays the record at the active cell.

When you close the dialog, the current record is selected for you.

Lets you insert a new record at any position in the database.

Excel Data Form Limited to 32 fields.

Dialog box adjusts its size based on the number of fields. In fact, it can take up the entire screen!

Dialog box uses only Text Boxes.

Doesn't scroll the screen for you and does not highlight the current record.

Always starts with the first record in the database.

Doesn't change your selection when you exit.

Adds new records only at the end of the database.

Enhanced Data Form

Includes an Undo button for Data Entry, Insert Record, Delete Record, and New Record.

Search criteria are stored in a separate panel, so you always know exactly what you're searching for.

Supports approximate matches while searching (*, ?, and #).

The complete VBA source code is available, so you can customize it to your needs.

Excel Data Form

Includes only a Restore button.

The search criteria are not always apparent.

Excel's Data Form does not.

Data Form is not written in VBA and cannot be customized.

The Enhanced Data Form is a commercial product (sort of). It is available on the companion CD-ROM,and it can be used and distributed freely. Access to the complete VBA source is available for a modest fee.

Was this article helpful?

0 0

Post a comment