| Expand the range of your Access proficiency with VBA programming, using this guide designed specifically for Access power users. Learn VBA fundamentals, then discover how to connect Access and VBA through ActiveX Data Objects (ADO), and how to extract, manipulate, and retrieve data using SQL queries. Benefit from expert advice on error handling, get the most out of forms, reports, and tables, and save time with VBA coding and debugging tips. From the basics to advanced techniques, this comprehensive treatment provides you with the information you need to produce the exact results you desire.
- Call up forms and reports using VBA
- Build dynamic Data Access Pages
- Program and assign record data sources to forms and reports
- Learn the fundamentals of SQL and how to use it in VBA
- Understand the ADO object model and its components
- Use modules, declare variables, build looping and decision structures, use procedures and functions, and build arrays
- Generate recordsets based on dynamic criteria
- Use Office menus and toolbars to invoke your code
- Develop applications that multiple users can run at the same time
|
|
|
 Professional XML DatabasesIn this book, we look at how to integrate XML into your current relational data source strategies. With the increasing amount of data stored in relational databases, and the importance of XML as a format for marking up data - whether it be for storage, display, interchange, or processing - you need to have command of four key skills: understanding... | | Physics of Tsunamis
This second edition reflects significant progress in tsunami research, monitoring and mitigation within the last decade. Primarily meant to summarize the state-of-the-art knowledge on physics of tsunamis, it describes up-to-date models of tsunamis generated by a submarine earthquake, landslide, volcanic eruption, meteorite impact, and moving... | | Excel 2010 Bible
The Bible series from Wiley Publishing, Inc. is designed for beginning, intermediate, and advanced
users. This book covers all the essential components of Excel and provides clear and practical
examples that you can adapt to your own needs.
In this book, I’ve tried to maintain a good balance between the basics that every... |
|
