Access VBA Programming

Charles E. Brown (New Milford, NJ) has been a computer trainer and consultant for 21 years. In the process he has developed and delivered training for many of the Fortune 500 companies including Exxon, Johnson & Johnson, RJR Reynolds/Nabisco, and the US Government. He has trained such diverse topics as Microsoft environment and the new Microsoft .NET environment. In addition he delivers programming training in Java for Learning Tree International. Brown has taught VBA to many beginner programmers as well has having done VBA programming for Swiss Bank Corporation, the US Government, NASA and Price Waterhouse Accounting. Brown is the author of Fireworks MX From Zero to Hero and Beginning Dreamweaver MX. He was also a contributor to the Macromedia Studio MX Environment. McGraw-Hill authors represent the leading experts in their fields and are dedicated to improving the lives, careers, and interests of readers worldwide

• Part I: Understanding the MS Access Environment 1 Introduction to VBA for Applications 2 Designing an Access Application 3 Access Development Without VBA 4 Customizing the Access Environment Part II: Understanding the Visual Basic for Applications Environment 5 Introducing the VBA Programming Environment 6 Programming Fundametals Using VBA 7 Understanding the Visual Basic Editor 8 VBA Language Components 9 Sub Procedures 10 Debugging VBA Code 11 Function Procedures Part III: Interacting with VBA 12 Forms 13 Reports 14 Menus and Toolbars 15 Changing the Access Environment Part IV: Advanced Access Programming Techniques 16 Database Security 17 Access and the Microsoft Office Environment 18 Access and the Web 19 Upgrading Part V: Application Development 20 Multiuser Applications 21 Beyond Microsoft Access Appendix The DoCmd Object