Microsoft® Office Access 2007 VBA

Index

Symbols

# (octothorpes), 44

.ini files, case study, 332–333

A

aborting

Do loop, 88

For...Next loop, 84–86

Abs() function, 48

absolute value of a number, returning, 48

Access object class modules, 15

Access SQL. See SQL

accessing VBE, 11

AccessObject object, properties, 214–217

ACE (Access Connective Engine), 229

active control, 144

adding

to combo box, case study, 138–140

unlisted values to combo boxes, 159–167

AddNew method, data, inserting

ADO object model, 292–293

DAO object model, 291–292

ADO (ActiveX Data Objects) object model

AddNew method, inserting data, 292–293

connecting to data source, 275–278

Delete method, 307–308

Execute method, inserting data, 290–291

Filter property, 302–304

Find method, 299–301

object hierarchy, 232–234 ...