O'Reilly logo

Access 2002 Programming by Example by Bob Villareal

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 List of Objects

The Name and Type fields are accessed by the TableOfTables query. They are the keys to setting up a query accessing database objects. The type of object list you want is determined by the Type field and, of course, the object you want is determined by the Name field. The Name field is also where the system objects are excluded by using a wildcard in the criterion. Reverse the changes you just made in Tools, Options, View and take the following steps to examine and run the query:

1.
Open the TableOfTables query in Design view.
2.
Click the drop-down box of the View button and switch to Design view. Notice the Name column criterion excludes the system tables by using Not Like MS* for criterion. Notice also that the ...

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