Access 2007 VBA Programmer's Reference by P-Wiley


More Info
									Access 2007 VBA Programmer's Reference
Author: Teresa Hennig
Author: Rob Cooper
Author: Geoffrey L. Griffith
Author: Armen Stein

Edition: 1

Access 2007 VBA Programmer's Reference covers a wide spectrum of programming topics relevant to
Access. Although it assumes the reader has some familiarity with VBA programming language, it begins
with a brief introduction to VBA. And to help you leverage the tools that Access provides, a chapter
highlights the new features in Microsoft Office Access 2007 -- including new wizards and GUI (graphical
user interface) elements that previously required VBA code, as well as new VBA features.The book also
discusses how to create and name variables, how to use Data Access Object (DAO) and ActiveX Data
Object (ADO) to manipulate data both within Access and within other applications, proper error handling
techniques, and advanced functions such as creating classes and using APIs. Key new objects such as
using Macros and the Ribbon are explored, too, as are forms and reports, the two most powerful tools for
working with and displaying data. Working with other applications is covered extensively both in a general
nature and for working specifically with Microsoft Office applications, Windows SharePoint Services, and
SQL Server. Of course, this book wouldn't be complete without discussing security issues and the
Developer Extensions.The ChaptersChapters 1--5 provide material that you need if you're new to Access
or VBA. After a review of Access 2007's new features, you explore the building blocks of VBA, including
objects, properties, methods, and events. And you're introduced to the VBA Editor and its various
debugging tools.Chapters 6 and 7 focus on using VBA to access data. Both DAO and ADO provide
methods for accessing data in Microsoft Access and other external data sources such as Informix, SQL
Server, and a variety of accounting programs.Chapters 8 and 9 provide detailed information on executing
and debugging VBA code. Every development project needs some debugging, even if you're an expert
developer. You'll see some easy ways to debug your code, and get some tips and tricks to make the
tedious process of debugging a bit easier. Error handling is for more than just trapping problems and
preventing crashes. It provides a powerful tool for interacting with users and adding functionality to
programs.Chapters 10 and 11 tackle forms and reports, two Access objects that can make particularly
heavy use of VBA. In many applications, forms and reports control what the user can see and do. With
the advent of report browsers, nearly all of the events that were available on forms are now accessible on
reports. So, in addition to using code to show or hide sections of reports and to provide special
formatting, you can now drill into the data underlying the report. These two chapters are packed with
information; you'll see how to use split screens on forms, create professional image controls, format
reports based on cross tab queries, enhance interactive reports, alternate row colors, and much
more.Advanced VBA programming information begins in the next four chapters (12--15) -- creating
classes in VBA, using APIs, and using SQL and VBA. Because the Office Ribbon is new, there is a
chapter dedicated to explaining how to customize and work with the ribbon.Chapters 16--22 provide
information about working with other programs, working with Windows, and controlling access to your
applications and files. They also discuss some techniques for deploying database solutions. You'll learn
to create tasks and e-mail in Outlook, perform a mail merge in Word, export data to an Excel
spreadsheet, and take information from Access, create a graph, and insert that graph into...
Author Bio
Teresa Hennig
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. <br>

Rob Cooper
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.
<br>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. <br>

Geoffrey L. Griffith
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. <br>

Armen Stein
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.<br>

To top