O

object.Add item parameter, 291 Object-based programming, 36-37 Object dependencies, viewing, 1 Object-oriented programming, 301 with Access VBA, 277-302 creating custom objects, 278-290 overview of, 277-278 working with collections, 291-294 Objects, 36, 65, 277 accessing, 41-42 grouping in collections, 292 Object type data, 52 ODBC. See Open database connectivity Off-by-one error, 157 Office assistants installing, 306

showing/hiding/animating with VBA, 308-310 OLE DB, as connection provider, 242

On Error GoTo statement, 203, 211

One-to-many relationship, 12

One-to-many table relationships, selecting cascade deletes in, 232, 233 OOP. See Object-oriented programming OpenConnection method, 287 Open database connectivity, 239, 242 Open Form Action, 24 Open function, 199, 200 Open icon, 6

Open method, 211, 241, 244, 285 Operator precedence, importance of, 60 Operators, 67 conditional, 70 in expressions, 68 Option Base statement, 58 Option buttons, 79, 82-85, 95

Option Compare Database program, 107, 109, 110-111

Option Compare Database statement, 58

Option Compare statement, 125

Option Explicit statement, 58, 66

Option group control, 79, 80-82

Option Group Wizard, 80, 83

Options, 58

Option statements, 58-59

OptionValue property, 83

Oracle, 213, 239

ORDER BY clause, 225, 226, 236

Order of operations, within parentheses, 60, 66

Order of preference, 59

Ordinal position, for retrieving result of SQL function,

253-254 OR keyword, in SQL queries, 220 Or operator, 70, 71, 95 Outer joins, 229, 236 Output mode, 201

Was this article helpful?

0 0

Post a comment