Microsoft Access 2010 Bible

1314

Index

query criteria, 201

resizing, 297

On Error GoTo 0 statements, 831

On Error GoTo Label statements, 830–831

On Error Resume Next statements, 831–832

On Error statements, trapping errors, 825–826

On Format event, 462–463

On Print event, 462–463

OnAction attribute, 1024

1NF (first normal form), 95–97

OnError action, 561, 1071–1073

one-to-many table relationships, 108–110

one-to-one table relationships, 107–108

online templates. See templates.

OnRetreat event, 462–463

OOP (object-oriented programming). See also class modules;

events; objects; property procedures.

benefits of, 981–986

cardinal rules for, 985–986

class events, 997–999

Class_Initialize event procedure, 997–998

Class_Terminate event procedure, 998–999

description, 970

encapsulation, 982

managing class interfaces, 983–985

simplifying tasks, 982–983

user interfaces, revealing, 985

Open dialog box

browsing to dBase files, 631–632

exclusive database opening, 757, 855

Open event, 457, 461

Open method, 510–512

OpenContacts, 1058

OpenDatabase method, 758

OpenForm action, 1060–1061

opening

CD-ROM files, 1267–1270

datasheets, 221

forms, 468–469

queries with macro actions, 1055, 1056

reports with conditions, 1061–1064

ribbons, 1045–1046

tables, 510

unbound forms, network applications, 782–783

opening a database

exclusively, 756–758

network applications, 756–758

for sharing, 756–758

OpenProducts, 1058

Numeric fields (continued)

query selection criteria, 151–152

Replication ID size, 52

Single size, 52

size, specifying, 52–53

wrong data type, 52

O

Object data type, VBA, 428

Object Designers tab, 650

object hierarchies, listing members of, 411

object hierarchy, displaying, 528

object libraries, Automation, 791–792

object list, sorting, 420

object name violations, 1176

Object Type option, 34

object variables, Automation, 791–792

object-oriented programming (OOP). See OOP

(object-oriented programming).

objects. See also OOP (object-oriented programming).

in applications, 971

defining, 972–973, 978–980

initializing, 997–998

overview, 970–971

terminating, 998–999

obsolete databases. See compatibility with older databases.

ODBC drivers, exporting through, 635

ODBC Refresh Interval option, 767

ODBC (Object Database Connectivity) tables

configuration options for SQL Server, 1204

linking to, 588, 590–591

ODBC Time-out property, 652

Office Backstage view. See Backstage area.

Office button, new features, 1254

Office Compatible certification, 1095

Office macro recorder, 808–810

OK button, 313–314

OLE Automation. See Automation.

OLE Object data, entering, 226

OLE Object data type

converting to other data types, 58

description, 54

indexing, 50, 73

sorting, 50, 147

types of data stored, 49

OLE objects

copying, 296–297

inserting in forms, 296–297

52_475348-bindex.indd 131452_475348-bindex.indd 1314 4/1/10 2:02 PM4/1/10 2:02 PM