Access 2007 Vba: Programmer'S Reference

0.0

Access 2007 VBA Programmer's Reference provides comprehensive coverage of the use of VBA for building Access applications. The typical reader would be expected to have some experience with VBA programming and have read at least an introductory tutorial, such as Beginning Access 2007 VBA. The authors provide with real-world code examples to demonstrate each programming topic. Introductory chapters provide a very brief overview of VBA and highlight what's new in Access 2007. About The Author Teresa Hennig is president of both the Pacific Northwest Access Developer Group and the Seattle Access Group, and is host for INETA's monthly webcasts. She was the coordinating author for Access 2003 VBA Programmer's reference, and continues to publish two monthly Access newsletters. In recognition of her expertise and dedication to the Access community, Teresa was awarded Microsoft Access MVP. Rob Cooper is a test lead on the Access team at Microsoft. During the Access 2007 release, he led the security efforts across the test team and worked on several new features including disabled mode, database encryption, Office Trust Center, and sorting, grouping and totals. Rob also led efforts around the Access object model and continues to provide direction around programmability and security in Access. A long-time fan of Access, Rob is a frequent speaker at the Seattle Access Group and PNWADG meetings and has written for the Microsoft Knowledge Base and Access Advisor. Geoffrey Griffith is an avid Access user who contributed to the Access 2007 product as a Software Design Engineer in Test for the Microsoft Office Access team. He enjoys participating in software community events by attending and speaking for local users groups and helping all those who would seek it. Armen Stein is a Microsoft Access MVP and the president of J Street Technology, Inc., a team of database application developers in Redmond, Washington. Armen is President Emeritus of the Pacific Northwest Access Developers Group, and has also spoken at Seattle Access and Portland Access Users Group meetings. He has taught database classes at Bellevue Community College, and also developed and taught one-day training classes on Access and Access/SQL Server development. Table of Contents Introduction Introduction To Microsoft Access Access, VBA, And Macros New Features In Access 2007 Using The VBA Editor VBA Basics Using DAO To Access Data Using ADO To Access Data Executing VBA VBA Error Handling Using VBA To Enhance Forms Enhancing Reports With VBA Customizing The Ribbon Creating Classes In VBA Extending VBA With Apis SQL And VBA Working With Office Applications Working With Sharepoint Database Security Understanding Client/Server Development With VBA Working With The Win32 Registry Using The ADE Tools Protecting Yourself With Access 2007 Security Appendix Appendix A Upgrading To Access 2007 Appendix B References For Projects Appendix C Calling Managed Code Appendix D DAO Object Method And Property Descriptions Appendix E ADO Object Model Reference Appendix F ADO Object Argument Information Appendix G The Access Object Model Appendix H Windows API Reference Information Appendix I Windows Registry Information Appendix J Access Wizards, Builders, And Managers Appendix K Reserved Words And Special Characters Appendix L Naming Conventions Appendix M Tips And Tricks Index Bibliography