Access.2007.VBA.Bibl..

FIGURE 12.14 Formatting axis number. The Format Axis dialog opens; I formatted the left axis number for U.S. Currency by select ...

When the PivotChart (or one of its components) is selected, you should see special PivotChart commands in the Design and Layout ...

FIGURE 12.18 Selecting a chart style from the palette. FIGURE 12.19 A PivotChart with contrasting color bars and a light backgro ...

For a computer presentation, a dark background may be preferable; Figure 12.20 shows the PivotChart with a dark background styl ...

To see all the available chart types, click the Other Charts command, then the All Chart Types com- mand at the bottom of the dr ...

FIGURE 12.23 The Create Chart dialog. Though most chart types are available in both Access and Excel, there are some differences ...

FIGURE 12.24 Access and Excel chart types. Emailing Shipping and Reordering Reports ............................................ ...

FIGURE 12.25 A form for replenishing inventory. FIGURE 12.26 A message when all products have enough inventory. If you click the ...

FIGURE 12.27 A form for editing product amounts. On the Shipping Reports and Reordering form, the “2x Reorder” button sets the R ...

FIGURE 12.28 A shipping report listing the products shipped today. FIGURE 12.29 The new PDF selection for saving a database obje ...

FIGURE 12.30 An email message with an attached PDF file created from an Access report. Clicking the “Send Reorder Requests” butt ...

The cmdReorderInventoryevent procedure is listed here: Private Sub cmdReorderInventory_Click() This error handler skips to the C ...

Ask for confirmation to set all ReorderAmount values to zero, and add the amount ordered to UnitsOnOrder: strTitle = “Confirmati ...

Adding More Functionality to Office IN THIS PART Chapter 13 Creating COM Add-ins with Visual Basic 6 Chapter 14 Creating Access ...

18_047026 pt03.qxp 4/2/07 9:53 PM Page 434 ...

O ffice 2000 introduced COM add-ins as a new development tool, an alternative to creating VBA add-ins for Access, Excel, Outlook ...

In earlier versions of Access, COM add-ins placed buttons on the menu or toolbar you specified, using the CommandBars collection ...

FIGURE 13.1 Copying the COM Add-In project files into the VB Projects folder. FIGURE 13.2 The COM Add-In project template select ...

FIGURE 13.3 A new VB project created from the COM Add-in project template. To set a reference in a VB 6 project, drop-down the P ...

FIGURE 13.5 References set to the Access and DAO object libraries in the VB References dialog. You can now modify the form (if y ...