N

named constants finding numeric equivalents, 601, 603 VBA versus VBScript, 601, 603 viewing in Object Browser, 164 NameSpace object, 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 New keyword, 234, 236 NewDoc function, 140-141 NewDocFromTemplate function, 142-143 NewTable procedure, 106-109 NoMatch property, 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 Nz function, 601

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 FileDialog object, 263, 264-270 history of data transfer techniques, 3-4 installing based on Windows version, 560-562 version issues, 627 Office menu. See also Access Options dialog Access Options dialog, 517, 523-524, 586 opening, 523-524 Properties command, 148 on Ribbon, 515 Save As submenu, 304 .oft file format, 237

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

Automation On Error Resume Next statement, 601,

617-619 OnAction property, 443 OnConnection event procedure, 443 OnConnection method, 574 OnDisconnection event procedure, 443 OnErrorGoTo error handler, 601 Open Database Connectivity (ODBC), 3, 4 OpenDatabase method, 99 OpenQuery method, 109, 482 OpenRecordsetCommand procedure, 113-116 OpenRecordsetSQL procedure, 111-113 OpenSpecificWorkbook function, 189-190 optimistic lock type, 118, 121 Outlook activating Journal component, 80 Application object, 234-235, 236 built-in contact ID fields, 359 comparing contact data with Access contact data, 359-390 CopyAccessAttsToOutlook procedure,

391-392

CopyAccessContactsToOutlook procedure, 390

CopyAllOutlookContactsToAccess procedure, 390 CopyOutlookAttsToAccess procedure,

392-393

CreateProjectAppts function, 245-247 CreateProjectTasks function, 253-254 ExportAppointmentsToOutlook function, 241-243

ExportFlatFileContactsToOutlook function, 255-258 exporting Access task and appointment data to, 72-78

exporting appointment data to Access, 243-245 exporting changing Access data to, 220-233 exporting task data to Access, 250-251

ExportTasksToOutlook function, 247-249 ImportApptsFromOutlook function, 243-245 ImportContactsFromOutlook function, 259-262

importing appointment data from Access, 241-243

importing mainframe data as Journal items, 79-81

import/link folder selections, 222-223 ImportOutlookContacts function, 361-365, 390

ImportTasksFromOutlook function, 250-251 linking Access tables to, 221-229 linking Calendar folder to Access tables, 224 linking Contacts folder to Access tables, 224-225

linking Tasks folder to Access tables, 223-224 Object Browser, 94

referencing items in VBA code, 240-241 refreshing contact data, 361-374 syntax for referencing objects, 235-240 working with appointments, 241-247 working with attachments, 391-396 working with contacts, 254-262 working with tasks, 247-254 Outlook Export.accdb sample database, 230, 231 Outlook object model

Explorer object, 234-235 Inspector object, 234-235 NameSpace object, 235 overview, 234 setting reference to, 74 Outlook Select Folder dialog, 360-361 Outlook.accdb sample database, 72 Output Documents folder, 264, 265-267

0 0

Post a comment