O

obj (Object) prefix, 55

object(s)

building class modules for Project Tracker, 357

characteristics of, 80

class module for in Customer Service, 481–488

creating custom methods for existing, 125–126

creating custom properties for existing, 124–125

creating your own, 101–127

defined, 79

elements of, 79–91

instantiating at runtime, 295

referring to, 93–94

seeing methods available for, 83

standardized way of naming, 55

using, 94–100

using class modules to create, 101–123

viewing using the Object Browser, 91–93

Object Browser

opening, 91, 92

viewing objects using, 91–93

Object data type, 50

Object navigation box, 27, 28

object variables

declaring and using, 53

declaring for Excel, 294

defined, 53

ObjectFormat parameter, 210

ObjectName parameter

for OutputTo, 249

for SendObject, 210

object-oriented programming. See OOP

object-oriented programming environment, 79–100

ObjectType parameter

for the ExportXML method, 209

for the OutputTo method, 249

for SendObject, 210

for the TransferDatabase method, 201

objProjects object, populating, 412, 428–429

ODBC database, importing data from, 201

ODBC data source name, 201

Office and Home Application Download Category, 214

Office Button, 79

Office SharePoint Server 2007, 221

On Click event, 37, 38, 87

On Click event procedure, 95

On Error statement, 72, 77

On Exit event, 86–87

On Load event, 116

1&1 Internet, 222

OOP (object-oriented programming), 79

Open Databases Using Record-Level Locking option, 317

Open Exclusive setting, 323

Open method

of the Connection object, 131

populating a recordset, 133

OpenDbConnection procedure

adding to modDatabaseLogic module, 492–493

adding to open database connections, 390, 405

OpenFileAttachment procedure, 385, 401

OpenForm action, 47, 48

optimistic locking, 317, 318

Option Explicit statement, 31, 32

Options parameter of the Recordset object, 134

OR, in an Activity Diagram, 8, 9, 10

Order By clause, 161–162

OtherFlags parameter, 209

Outlook, 302–305

Outlook Calendar, 163–164

OutputFile parameter for the OutputTo method, 249

OutputFormat parameter for the OutputTo method, 249

OutputQuality parameter for the OutputTo method, 249

OutputTo method, 211, 248–251

OutputToHTML procedure, 250