Access.2007.VBA.Bibl..

Going Beyond the Basics 12

Figure 12.2 shows the main menu of the Northwind Plus sample database, with buttons for open-

ing the two main forms, and buttons to select the Documents and Templates folders. The folder

selection buttons function like the similar controls in several other chapters, using a Folder Picker

dialog created by the Office FileDialog object.

FIGURE 12.2

The main menu of the Northwind Plus sample database.

I could have determined which orders were ready to ship just by examining the avail-

able inventory and the date the order is required, but in the real world these are not the

only factors to consider — if there aren’t enough people to do the shipping, or all the trucks are out

on the road, you can’t ship the product, even if there is enough inventory.

Figure 12.3 shows the order selection form.

NOTENOTE