Skip to Main Content
Access 2002 Programming by Example
book

Access 2002 Programming by Example

by Bob Villareal
January 2002
Beginner content levelBeginner
576 pages
13h 23m
English
Que
Content preview from Access 2002 Programming by Example

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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Access 2003 Programming by Example with VBA, XML, and ASP

Access 2003 Programming by Example with VBA, XML, and ASP

Julitta Korol
Microsoft® Access® 2010 Programmer's Reference

Microsoft® Access® 2010 Programmer's Reference

Teresa Hennig, Rob Cooper, Geoffrey L. Griffith, Jerry Dennison

Publisher Resources

ISBN: 0789725940Purchase book