FIGURE 12.24
Access and Excel chart types.Emailing Shipping and Reordering Reports ......................................................................
After you ship out orders, using the shipping labels described in an earlier section, you might need
to produce reports detailing the amounts of different products that were shipped and the amounts
that need to be ordered to replenish stock, and then email these reports to various persons. The
Shipping Reports and Reordering form, shown in Figure 12.25, lets you see the inventory for all
products where the amount in stock plus the amount on order is at or under the reorder level for
that product. The ReorderAmount field (initially set to zero for all products) indicates the number
of cases you want to reorder.Since this form only has data if at least one product is below the inventory reorder level, when you
click the “Email Shipping and Reordering Reports” button on the main menu, if there is enough
inventory for all products, you will get the message shown in Figure 12.26.Part II Writing VBA Code to Exchange Data between Office Components