Access 2007 VBA Programmer's Reference
Published on 15. May 2007
Book
Paperback/Softback
1152 pages
978-0-470-04703-3 (ISBN)
Description
Access 2007 VBA Programmer's Reference
Written by Access MVPs and Microsoft Access testers, this resource will give you the tools to leverage Access 2007's built-in functionality and VBA in order to build more dynamic applications. It explores all aspects of VBA programming for Access and describes the latest innovations. You'll also find several commonly used techniques and sample code to help you get started, as well as expert tips to make your code easier to maintain.
The expert author team will show you how to create and name variables, manipulate data using Data Access Object (DAO) and ActiveX(r) Data Object (ADO), handle errors, and create classes. You'll also learn how to utilize the latest wizards as well as modify and enhance the code that the wizards create. And you'll learn how to take advantage of key new objects, enhanced macros, and the Office Ribbon.
What you will learn from this book
* All about Access 2007's new features and the building blocks of VBA
*
Ways to debug your code and avoid common pitfalls
*
Techniques for accessing data in Access and other external data sources
*
Steps for creating and enhancing forms and reports
*
Methods for controlling access to your applications and files
*
How to use VBA with APIs and other Office applications
*
Tips for using the Windows(r) Registry and ADE tools
Who this book is for
This book is a comprehensive resource for Access users and VBA developers who want to increase the power of Access using VBA.
Wrox Programmer's References are designed to give the experienced developer straight facts on a new technology, without hype or unnecessary explanations. They deliver hard information with plenty of practical examples to help you apply new tools to your development projects today.
Written by Access MVPs and Microsoft Access testers, this resource will give you the tools to leverage Access 2007's built-in functionality and VBA in order to build more dynamic applications. It explores all aspects of VBA programming for Access and describes the latest innovations. You'll also find several commonly used techniques and sample code to help you get started, as well as expert tips to make your code easier to maintain.
The expert author team will show you how to create and name variables, manipulate data using Data Access Object (DAO) and ActiveX(r) Data Object (ADO), handle errors, and create classes. You'll also learn how to utilize the latest wizards as well as modify and enhance the code that the wizards create. And you'll learn how to take advantage of key new objects, enhanced macros, and the Office Ribbon.
What you will learn from this book
* All about Access 2007's new features and the building blocks of VBA
*
Ways to debug your code and avoid common pitfalls
*
Techniques for accessing data in Access and other external data sources
*
Steps for creating and enhancing forms and reports
*
Methods for controlling access to your applications and files
*
How to use VBA with APIs and other Office applications
*
Tips for using the Windows(r) Registry and ADE tools
Who this book is for
This book is a comprehensive resource for Access users and VBA developers who want to increase the power of Access using VBA.
Wrox Programmer's References are designed to give the experienced developer straight facts on a new technology, without hype or unnecessary explanations. They deliver hard information with plenty of practical examples to help you apply new tools to your development projects today.
More details
Other editions
Additional editions
Teresa Hennig | Rob Cooper | Geoffrey L. Griffith
Access 2007 VBA Programmer's Reference
E-Book
06/2011
Wrox
€27.99
Available for download
Teresa Hennig | Rob Cooper | Geoffrey L. Griffith
Access 2007 VBA Programmer's Reference
E-Book
07/2007
Wrox
€27.99
Available for download
Persons
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.
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.
Content
Introduction.
1. Introduction to Microsoft Access.
2. Access, VBA, and Macros.
3. New Features in Access 2007.
4. Using the VBA Editor.
5. VBA Basics.
6. Using DAO to Access Data.
7. Using ADO to Access Data.
8. Executing VBA.
9. VBA Error Handling.
10. Using VBA to Enhance Forms.
11. Enhancing Reports with VBA.
12. Customizing the Ribbon.
13. Creating Classes in VBA.
14. Extending VBA with APIs.
15. SQL and VBA.
16. Working with Office Applications.
17. Working with SharePoint.
18. Database Security.
19. Understanding Client/Server Development with VBA.
20. Working with the Win32 Registry.
21. Using the ADE Tools.
22. Protecting Yourself with Access 2007 Security.
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.
1. Introduction to Microsoft Access.
2. Access, VBA, and Macros.
3. New Features in Access 2007.
4. Using the VBA Editor.
5. VBA Basics.
6. Using DAO to Access Data.
7. Using ADO to Access Data.
8. Executing VBA.
9. VBA Error Handling.
10. Using VBA to Enhance Forms.
11. Enhancing Reports with VBA.
12. Customizing the Ribbon.
13. Creating Classes in VBA.
14. Extending VBA with APIs.
15. SQL and VBA.
16. Working with Office Applications.
17. Working with SharePoint.
18. Database Security.
19. Understanding Client/Server Development with VBA.
20. Working with the Win32 Registry.
21. Using the ADE Tools.
22. Protecting Yourself with Access 2007 Security.
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.