O'Reilly logo

F. Scott Barker's Microsoft® Access 2000 Power Programming by F. Scott Barker

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CREATING A GENERIC CODE TABLE EDITOR

Most applications use a number of code tables.

Note

A code table is a list of values used in a set field. The list will usually be static but can be dynamic. An example of a code table would be the tblRatings table.

Coming up with a method for handling them is helpful so that when a new one is added, minimal work needs to be done.

A generic code table editor is probably one of the most simplistic of the techniques shown in this book. All it consists of is one main form and whatever subforms are needed for the various code tables. Figure 28.8 shows the main form, with the tblCategories codes displayed in the subform.

Figure 28.8. The same main form is used with multiple subforms.

The main form used for this ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required