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

Chapter 12. Access Visual Basic Tools, T... > Creating a List of Fields

Creating a List of Fields

The list boxes you have been examining have performed as pick lists. What if you wanted a pick list of fields for each table in your database? You could enumerate the fields collection in much the same way that you enumerated the tables collection. However, there is a much easier built-in technique for enumerating the fields of any table that is often overlooked. You can use the Field List row source type of a list box to list all the fields of whatever row source table is selected. You can use this option to list the fields of every table in your database at the click of a mouse button. Then simply print the form for a hard copy of your list.

Examine the following simple procedure that lists the fields of every table that you click on in your database:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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