Access.2007.VBA.Bibl..

FIGURE 1.24 Creating a PivotTable. A new form based on the data source opens in PivotTable view (see Figure 1.25), with the Fiel ...

FIGURE 1.25 A newly created PivotTable, ready to select fields. FIGURE 1.26 A completed PivotTable. Storing and Displaying Data ...

PivotCharts ...................................................................................................... Making a Pivo ...

FIGURE 1.28 The PivotChart with fields assigned to its drop zones. The next step is to give names to the chart’s vertical and ho ...

To make the chart’s Legend visible (generally a good idea), click the Legend button in the Show/Hide group of the Design tab of ...

See Chapter 3 for information on creating Excel worksheets and charts filled with Access data, and Chapter 12 for information on ...

...

I f you need to produce documents with more sophisticated formatting than is available in an Access report, your best option is ...

In most of my Automation code working with other Office applications (Word, Excel, and Outlook), I use the GetObjectfunction in ...

.ApplyStyleHeadingRows = True .ApplyStyleLastRow = False .ApplyStyleFirstColumn = True .ApplyStyleLastColumn = False .ApplyStyle ...

If you don’t know the VBA syntax for an operation, you can record a Word macro to create a procedure containing the code, though ...

Bookmarks ................................................................................................................ As an ...

Part I The Office Components and What They Do Best continued Curiously, the user address information is entered in a different l ...

Creating Word Documents from Access 2 This opens the Field dialog (similar to the one in Word 2003), where you can select the Us ...

To insert a bookmark in a document or template, select Bookmark from the Links group on the Insert tab, as in Figure 2.2. It is ...

FIGURE 2.4 Turning on bookmark display in the Word Options dialog. Figure 2.5 shows the second (envelope) page of the Milano Wor ...

In code for this chapter’s sample database, the assumption is that the Word templates are located in the default folder, which i ...

Dim strRecipientZip As String Dim strPrompt As String Dim strTitle As String Dim strSalutation As String Dim fso As New Scriptin ...

Write information to Word bookmarks in the document: With appWord.Selection .Goto what:=wdGoToBookmark, Name:=”LetterDate” .Type ...

Word is not running; open Word with CreateObject: Set appWord = CreateObject(“Word.Application”) Resume Next Else MsgBox “Error ...