Access 2002 Programming by Example

How to Use DAO and ADO to Enumerate Objects

There might be times when you need to enumerate objects. Why is this important? Suppose you wanted to show the users a dynamic list of reports from which he or she could select for printing. Or suppose that you wanted the user to select from a list of tables for exporting or importing. You could combine the code presented in this chapter with the “pick-list” techniques you have learned to design creative applications for users. In fact, Chapter 18, “Working with Data from External Sources,” explains how to do just that.

There are many ways to enumerate Access objects. One method requires no programming at all. You simply construct a query. Actually, it has already been done for you. The query makes ...