Access.2007.VBA.Bibl..

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

Automation

On Error Resume Nextstatement, 601,

617–619

OnActionproperty, 443

OnConnectionevent procedure, 443

OnConnectionmethod, 574

OnDisconnectionevent procedure, 443

OnErrorGoToerror handler, 601

Open Database Connectivity (ODBC), 3, 4

OpenDatabasemethod, 99

OpenQuerymethod, 109, 482

OpenRecordsetCommandprocedure, 113–116

OpenRecordsetSQLprocedure, 111–113

OpenSpecificWorkbookfunction, 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

CopyAccessAttsToOutlookprocedure,

391–392

CopyAccessContactsToOutlookprocedure,

390

CopyAllOutlookContactsToAccess

procedure, 390

CopyOutlookAttsToAccessprocedure,

392–393

CreateProjectApptsfunction, 245–247

CreateProjectTasksfunction, 253–254

ExportAppointmentsToOutlookfunction,

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

ExportTasksToOutlookfunction, 247–249

ImportApptsFromOutlookfunction, 243–245

ImportContactsFromOutlookfunction,

259–262

importing appointment data from Access,

241–243

importing mainframe data as Journal items,

79–81

import/link folder selections, 222–223

ImportOutlookContactsfunction, 361–365,

390

ImportTasksFromOutlookfunction, 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

Explorerobject, 234–235

Inspectorobject, 234–235

NameSpaceobject, 235

overview, 234

setting reference to, 74

Outlook Select Folder dialog, 360–361

Outlook.accdb sample database, 72

Output Documents folder, 264, 265–267

P

Paradox. Seelegacy files

Parameter object, 92

PDF files, saving to, 415, 428, 429

pessimistic lock type, 118

Index P

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