Index_D


D

Data Access Objects (DAO), 69

See also objects

Data Access Pages, 10, 317

creating in Design View, 324–327

generating, 317–321, 322

Page Wizard, 317–320

saving, 321–324

and VBA, 327–328

data types, ADO equivalents to, 179

database applications

components, 29–30

defined, 5

database engine, 29

Database Splitter Wizard, 358–362

Database window, 5–7

databases

automatically opening in shared mode, 350

defined, 5

sharing, 349–350

splitting, 358–362

DateDiff, 210

DatePart, 209–210

Debug object, 196

Debug toolbar, 117

debugging

tools, 192–199

See also error handling; errors

decentralization vs. centralization, 362–363

decision structures. See decision-making structures

decision-making structures, 92, 93–98

defaults, 340

definition and analysis of requirements, 14–16

DeleteObject, 392–393

design, 174

Design View, 6, 7

design-time errors, 182

development of the design, 17–23

digital certificates, 296–298

digital signatures, 295–298

Dim keyword, 141

Do loops, 100–104

Do Until loops, 103–104

Do While loops, 101–103

DoCmd object, 70–71, 385–386

AddMenu, 386

ApplyFilter, 386–387

Beep, 387–388

calling reports from VBA, 246–247

CancelEvent, 388–389

Close, 389–390

CopyDatabaseFile, 390

CopyObject, 390–392

DeleteObject, 392–393

DoMenuItem, 393

Echo, 393–394

FindNext, 394–395

FindRecord, 395–396

GoToControl, 397

GoToPage, 397–398

GoToRecord, 398–399

Hourglass, 399

Maximize, 399–400

Minimize, 400

MoveSize, 400–401

OpenDataAccessPage, 401–402

OpenDiagram, 402

OpenForm, 402–404

OpenFunction, 404

OpenModule, 405

OpenQuery, 405–406

OpenReport, 406–407

OpenStoredProcedure, 408

OpenTable, 408–409

OpenView, 409–410

OutputTo, 410–412

PrintOut, 412–413

Quit, 413–414

Rename, 414–415

RepaintObject, 415

Requery, 415

Restore, 416

RunCommand, 416

RunMacro, 416–417

RunSQL, 417–418

Save, 418–419

SelectObject, 419–420

SendObject, 420–422

SetMenuItem, 422

SetWarnings, 422–423

ShowAllRecords, 423

ShowToolbar, 423–424

TransferDatabase, 425

TransferSpreadsheet, 425

TransferSQLDatabase, 425

TransferText, 425

documentation, 24–25

DocumentProperty object, 302

DoMenuItem, 393

dynamic arrays, 105, 107–109

See also static arrays

dynamic technology, 316




Access VBA Programming
Microsoft Access VBA Programming for the Absolute Beginner
ISBN: 1598633937
EAN: 2147483647
Year: 2006
Pages: 214
Authors: Michael Vine

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net