Access VBA Programming / Edition 1

Access VBA Programming / Edition 1

by Charles Brown, Ron Petrusha
     
 

ISBN-10: 0072231971

ISBN-13: 9780072231977

Pub. Date: 08/23/2004

Publisher: McGraw-Hill Professional Publishing

Take a look at this great application of VBA and learn to expand the capabilities of Access with simple programming. Author Charles E. Brown shows you step-by-step how to create your own code, work with Object-Oriented Programming, and more. Plus, discover and utilize key programming concepts that can be applied beyond VBA.

Overview

Take a look at this great application of VBA and learn to expand the capabilities of Access with simple programming. Author Charles E. Brown shows you step-by-step how to create your own code, work with Object-Oriented Programming, and more. Plus, discover and utilize key programming concepts that can be applied beyond VBA.

Product Details

ISBN-13:
9780072231977
Publisher:
McGraw-Hill Professional Publishing
Publication date:
08/23/2004
Series:
Programming Ser.
Pages:
464
Product dimensions:
7.40(w) x 9.10(h) x 0.92(d)

Table of Contents

Introductionxvii
Part IUnderstanding the MS Access Environment
Chapter 1Introduction to VBA for Applications3
History of Microsoft Access4
Developing in Access5
The Future of Microsoft Access10
Summary11
Chapter 2Designing an Access Application13
Steps in the Development Process14
Definition and Analysis of Requirements14
Evaluation of Requirements16
Development of the Design17
Implementation and Testing23
Documentation24
Maintenance25
Summary26
Chapter 3Access Development Without VBA27
System Architecture28
Understanding a Database Application29
Working Without VBA30
Events34
Naming Conventions38
Predefined Templates40
Switchboard Manager41
Summary45
Chapter 4Customizing the Access Environment47
Interacting with Access47
Customizing Shortcut Menus55
Creating Menus56
Attaching Code to a Custom Menu Item57
Summary60
Part IIUnderstanding the Visual Basic for Applications Environment
Chapter 5Introducing the VBA Programming Environment63
Introduction to VBA63
The VBA Model64
The Concept of Objects67
The VBA Editor71
Summary78
Chapter 6Programming Fundametals Using VBA79
Programming Fundamentals79
Control Structures92
Arrays104
Summary111
Chapter 7Understanding the Visual Basic Editor113
Opening the VBA Editor113
Highlights of the Menu System115
The Debug, Edit, and UserForm Toolbars117
The Project Explorer118
Managing Modules119
Properties Window122
The Object Browser123
References127
Using VBA Editor Options128
Getting Help135
Starting a New Procedure in the VBA Editor137
Summary138
Chapter 8VBA Language Components139
Objects in VBA139
Intrinsic Constants140
Basic VBA Programs Using Forms142
Connecting with Microsoft Access151
SQL (Structured Query Language)153
SQL and VBA157
Output161
Summary163
Chapter 9Sub Procedures165
Declaring a Procedure165
Functions168
Parameters169
Design and Scope174
Global and Static Variables175
Using Procedures to Change a Database Structure176
Summary180
Chapter 10Debugging VBA Code181
Basics of Error Handling182
The Err Object187
The Errors Collection189
Tools for Debugging Code192
Summary200
Chapter 11Function Procedures201
Subs vs. Functions201
Built-in Functions203
Date and Time Functions208
Payment Function212
Summary214
Part IIIInteracting with VBA
Chapter 12Forms217
Forms and Data217
Assigning Recordsets Dynamically222
Appending and Editing Data224
Controlling Controls in Forms225
Summary232
Chapter 13Reports233
Anatomy of a Report233
Report Wizard236
Specialized Reports240
Calling the Report from VBA246
Creating a Report Programmatically247
Summary252
Chapter 14Menus and Toolbars253
Understanding Command Bars253
Creating a Toolbar255
Menus262
Submenus266
Summary267
Chapter 15Changing the Access Environment269
The Startup Properties269
Changing Options272
Summary280
Part IVAdvanced Access Programming Techniques
Chapter 16Database Security283
Access and Security283
User-Level Security288
Security and Access 2003294
Summary299
Chapter 17Access and the Microsoft Office Environment301
Shared Objects302
Connecting with Other Microsoft Office Products307
Summary314
Chapter 18Access and the Web315
The Mechanics of the Web315
Data Access Pages317
XML (Extended Markup Language)328
Summary331
Chapter 19Upgrading333
Microsoft Access vs. SQL Server334
Access Data Projects335
Working with an ADP File342
Summary346
Part VApplication Development
Chapter 20Multiuser Applications349
Sharing the Database349
Handling Resource Contention and Conflicts351
Improving Application Performance357
Summary366
Chapter 21Beyond Microsoft Access367
VBA and Microsoft Office368
Visual Basic373
VBScript381
Transition to Microsoft .NET384
Summary384
AppendixThe DoCmd Object385
AddMenu386
ApplyFilter386
Beep387
CancelEvent388
Close389
CopyDatabaseFile390
CopyObject390
DeleteObject392
DoMenultem393
Echo393
FindNext394
FindRecord395
GoToControl397
GoToPage397
GoToRecord398
Hourglass399
Maximize399
Minimize400
MoveSize400
OpenDataAccessPage401
OpenDiagram402
OpenForm402
OpenFunction404
OpenModule405
OpenQuery405
OpenReport406
OpenStoredProcedure408
OpenTable408
OpenView409
OutputTo410
PrintOut412
Quit413
Rename414
RepaintObject415
Requery415
Restore416
RunCommand416
RunMacro416
RunSQL417
Save418
SelectObject419
SendObject420
SetMenultem422
SetWarnings422
ShowAllRecords423
ShowToolbar423
TransferDatabase425
Transferspreadsheet425
TransferSQLDatabase425
TransferText425
Index427

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >