• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 12. Access Visual Basic Tools, T... > How to Use DAO and ADO to Enumerate ...

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 more sense when you understand which objects are being accessed by the query. You can see a system table named MSysObjects in the Database window simply by clicking Tools, Options, View from the Access menu bar and clicking both Hidden objects and System objects. Figure 12.4 shows the View menu.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint