Access.2007.VBA.Bibl..

Microsoft Word (continued)

sending letters to single Access contacts,

150–158

setting User Templates folder path, 604–605

setting Workgroup Templates folder path,

604–605

user information fields, 31–33

using templates for creating formatted

documents, 30–45

version issues, 146

Modified Northwind.accdb sample database, 11

MSDE (Microsoft Database Engine), 629, 631

MSE (Microsoft Script Editor), 592–597

N

named constants

finding numeric equivalents, 601, 603

VBA versus VBScript, 601, 603

viewing in Object Browser, 164

NameSpaceobject, 234, 235

naming conventions, 11, 16

Navigation Options dialog, 475, 524, 630

.NET Framework, adding support to Office,

559–573

.NET Programmability Support components,

561–562

New Document from Template.vbs script, 614–616

Newkeyword, 234, 236

NewDocfunction, 140–141

NewDocFromTemplatefunction, 142–143

NewTableprocedure, 106–109

NoMatchproperty, 110

normalizing, defined, 348

Northwind databases, 631

Northwind Plus.accdb sample database, 397, 398,

403

Northwind 2007.accdb sample database, 90

Northwind.accdb sample database, 611, 612

Norton Internet Worm Protection warning, 648

Nzfunction, 601

O

Object Browser

finding numeric equivalents of named constants,

601, 603

Folder object, 235

opening, 139

overview, 94

viewing Access object model components,

275–276

object linking and embedding (OLE), 4. See also

Automation

object models

defined, 139

Excel, 187–191

Outlook, 234–241

referencing VB projects to, 438–439

role of Object Browser, 94

Word, 139–144

Object type variables, 236

ODBC (Open Database Connectivity), 3, 4

ODBC SQL Server Setup Wizard, 666–669

Office

Access version issues, 263–264

adding .NET support to, 559–573

changing installation in Windows Vista,

560–562

Custom UI Editor, 518–519

customization deficiency, 520–521

customizing user interface, 520

FileDialogobject, 263, 264–270

history of data transfer techniques, 3–4

installing based on Windows version, 560–562

version issues, 627

Office menu. See alsoAccess Options dialog

Access Options dialog, 517, 523–524, 586

opening, 523–524

Properties command, 148

on Ribbon, 515

Save As submenu, 304

.oftfile format, 237

M Index

25_047026 bindex.qxp 4/2/07 9:58 PM Page 688