Access.2007.VBA.Bibl..

Part II Writing VBA Code to Exchange Data between Office Components continued You should get a success message: Success messag ...

Going Beyond the Basics 12 Click Create to save the package file to a location of your choice: If this is the first time you ha ...

Part II Writing VBA Code to Exchange Data between Office Components continued You can click the Show Signature Details to view ...

Going Beyond the Basics 12 Figure 12.2 shows the main menu of the Northwind Plus sample database, with buttons for open- ing the ...

FIGURE 12.3 The form used for inspecting orders and marking them for shipment. The Select Orders for Shipping form (frmSelectOrd ...

n CategoryName n ReadyToShip, a Boolean field with a criterion of Trueto select orders that are ready to ship The cmdCreateLabel ...

Set the Word Application variable: Set appWord = GetObject(, “Word.Application”) appWord.Visible = True Get User Templates and D ...

Set up a recordset (rstShip) based on the qrySelectedNorthwindShippingLabelsquery, which has one record for each product on a se ...

For orders with ShipPartial unchecked, can’t ship the order because one product has inadequate inventory: strTitle = “Inadequate ...

Set variables with information to print on all the labels for this order: strCategory = rstOrder![CategoryName] strOrderDate = C ...

.EndKey Unit:=wdLine .Font.Bold = False .TypeText strShipName .TypeParagraph Indent the left margin to match the tab setting, so ...

strSaveNameAndPath = strDocsPath & strSaveName Debug.Print “Save name: “ & strSaveName On Error Resume Next Check for th ...

strTitle = “Set of labels created” strPrompt = _ “A set of shipping labels created “ _ & “for Order ID “ & lngOrderID _ ...

& “order shipped on “ _ & Format(Date, “dd-mmm-yyyy”) MsgBox strPrompt, vbInformation, strTitle ErrorHandlerExit: Figure ...

rst.MoveFirst GetDocumentsPath = rst![DocumentsPath] & “\” rst.Close ErrorHandlerExit: Exit Function ErrorHandler: MsgBox “E ...

Every development project has unique requirements; when using Access to create mailing labels (or any other type of Word documen ...

FIGURE 12.8 Exporting a query to Excel using a Ribbon command. On the Export dialog, edit the worksheet name as desired, and br ...

Open the newly created worksheet in Excel. Click anywhere in the data range, select the Insert tab of the Ribbon, and select Pi ...

FIGURE 12.11 The Create PivotTable with PivotChart dialog. The new, blank PivotChart appears, as shown in Figure 12.12. FIGURE ...

The layout of a PivotChart is different in Excel than in Access (a discrepancy Microsoft should clear up, but that is another m ...