• Überblick

Microsoft Access 2010 VBA Programming Inside Out

The ultimate in-depth reference

You´re beyond the basics, so dive right in and customize, automate, and extend Access-using Visual Basic* for Applications (VBA). This supremely organized reference is packed with hundreds of timesaving solutions, troubleshooting tips, and workarounds. It´s all muscle and no fluff. Discover how the experts use VBA to exploit the power of Access - and challenge yourself to new levels of mastery!

• Enhance your application with VBA built-in functions and SQL code
• Use the Access Object Model to work with data in forms and reports
• Manipulate data using SQL, queries, and recordsets with Data Access Objects (DAO)
• Create classes for handling form and control events
• Connect your Access database to different sources of data
• Effectively plan how to upsize an existing Access database to Microsoft SQL Server®
• Dynamically update Microsoft Excels spreadsheets from your database
• Migrate your Access database directly to the cloud using SQL Azure

Contents at a Glance

Part 1: VBA Environment and Language

• Chapter 1: Using the VBA Editor and Debugging Code 3
• Chapter 2: Understanding the VBA Language Structure 39
• Chapter 3: Understanding the VBA Language Features 89

Part 2: Access Object Model and Data Access Objects (DAO)

• Chapter 4: Applying the Access Object Model 127
• Chapter 5: Understanding the Data Access Object Model 161

Part 3: Working with Forms and Reports

• Chapter 6: Using Forms and Events 231
• Chapter 7: Using Form Controls and Events 273
• Chapter 8: Creating Reports and Events 323

Part 4: Advanced Programming with VBA Classes

• Chapter 9: Adding Functionality with Classes 339
• Chapter 10: Using Classes and Events 359
• Chapter 11: Using Classes and Forms 381

Part 5: External Data and Office Integration

• Chapter 12: Linking Access Tables 395
• Chapter 13: Integrating Microsoft Office 437

Part 6: SQL Server and SQL Azure

• Chapter 14: Using SQLServer483
• Chapter 15: Upsizing Access to SQL Server 543
• Chapter 16: Using SQL Azure 589

Part 7: Application Design

• Chapter 17: Building Applications 631
• Chapter 18: Using ADO and ADOX 659

About the Author Andrew Couch:

Andrew Couch has been working with Microsoft Access since 1992, developing, training, and consulting on Client-Server design projects. With his wealth of experience in Access and SQL products, he has been able to mentor software houses, blue chip companies, and independent developers. Alongside running his own consultancy, Andrew has been heavily involved in the developer community and jointly founded the UK Access User Group more than 13 years ago. He has also earned Access MVP status for the last 5 years.

Andrew´s passion lies with VBA programming and extending the reach of VBA programmers into cloud computing and the NET environment. He hopes that this book serves as an example of his dedication to this exceptional piece of technology and its application.

In addition to consulting and regularly speaking at community events, Andrew has developed the Migration Upsizing SQL Tool (MUST), which is a tool that allows users to easily convert Access Databases to SQL Server by using an Access-based application. Due to the success of MUST, which is used by over 150 companies, SQL Translation capabilities and WebForm code generators for NET were added to the product range. More recently the MUST technologies have been extended further to deliver automated services for converting Access database to a web legal format for publishing to SharePoint.