Microsoft Office Tutorials and References
In Depth Information
Book VIII: Programming in VBA
Contents at a Glance
Contents at a Glance
Chapter 1: What the Heck Is VBA? .............................537
Getting Acquainted with VBA Code .......................................................... 537
Enabling VBA Code ...................................................................................... 541
Working with Visual Basic Editor .............................................................. 543
Discovering Code As You Go ..................................................................... 553
Chapter 2: Writing Code ......................................557
Seeing How VBA Works .............................................................................. 557
Understanding VBA Syntax ........................................................................ 558
Writing Your Own VBA Procedures .......................................................... 563
Typing and Editing in the Code Window .................................................. 570
Testing and Running Your Code ................................................................ 575
Chapter 3: Writing Smarter Code...............................581
Creating Variables and Constants ............................................................. 581
Making Decisions in VBA Code .................................................................. 589
Executing the Same Code Repeatedly ....................................................... 595
Using Custom Functions ............................................................................. 600
Chapter 4: Controlling Forms with VBA .........................605
Displaying Custom Messages ..................................................................... 605
Opening Forms with DoCmd ...................................................................... 608
Changing Form Controls with VBA ............................................................ 612
Understanding Objects and Collections ................................................... 619
Chapter 5: Using SQL and Recordsets ..........................629
Recordsets and Object Models .................................................................. 629
SQL and Recordsets .................................................................................... 633
Action Queries in VBA ................................................................................ 638
Connection Cleanup .................................................................................... 640
Chapter 6: Debugging Your Code...............................641
Recognizing Types of Program Errors ...................................................... 641
Fixing Compiler Errors ................................................................................ 642
Trapping Runtime Errors ............................................................................ 643
Dealing with Logical Errors ........................................................................ 647
 
Search JabSto ::




Custom Search