Stockman / Simpson Access 2007 VBA Programming For Dummies

1. Auflage 2011
ISBN: 978-1-118-05075-0
Verlag: John Wiley & Sons
Format: EPUB
Kopierschutz: Adobe DRM (»Systemvoraussetzungen)

E-Book, Englisch, 416 Seiten, E-Book

If you've been using Access for a while, you'reprobably aware of its power and potential and itching to takeadvantage of both. Access 2007 VBA Programming ForDummies takes you beyond forms and reports and shows you how touse VBA to create killer Access databases and applications. Thisgentle introduction to VBA programming covers everything you needto get started, including:
* Basic programming skills and concepts
* Explanations of modules, procedures, objects, andarguments
* Access-unique programming activities, including SQL andrecordsets
* How to use the Visual Basic editor
* Creating dialog boxes, lists, drop-down menus, andfunctions
* Integrating with other Office applications
* Ready-to-use VBA code examples to type in or copy and pastefrom the Web
Completely revised to reflect all changes found in MicrosoftAccess 2007, Access 2007 VBA Programming For Dummies givesyou access to Access like you've never had it before.

Autoren/Hrsg.

Stockman, Joseph C.

Simpson, Alan

Inhaltsverzeichnis

Introduction 1
Part I: Introducing VBA Programming 7
Chapter 1: Where VBA Fits In 9
Chapter 2: Your VBA Toolkit 21
Chapter 3: Jumpstart: Creating a Simple VBA Program 35
Part II: VBA Tools and Techniques 49
Chapter 4: Understanding Your VBA Building Blocks 51
Chapter 5: Controlling Access through VBA 71
Chapter 6: Programming Access Forms 87
Part III: VBA, Recordsets, and SQL 115
Chapter 7: The Scoop on SQL and Recordsets 117
Chapter 8: Putting Recordsets to Work 147
Part IV: Applying VBA in the Real World 173
Chapter 9: Creating Your Own Dialog Boxes 175
Chapter 10: Customizing Combo Boxes and List Boxes 201
Chapter 11: Creating Your Own Functions 239
Chapter 12: Testing and Debugging Your Code 265
Part V: Reaching Out with VBA 293
Chapter 13: Using VBA with Multiple Databases 295
Chapter 14: Integrating with Other Office Applications 315
Part VI: The Part of Tens 349
Chapter 15: Ten Commandments of Writing VBA 351
Chapter 16: Top Ten Nerdy VBA Tricks 357
Index 367

Über Autor(innen)

Joe Stockman is an independent consultant, softwaredesigner, and author who has been using Microsoft Access since itsinitial release. He's also developed courseware and taughtclasses in Access and VBA. Joe developed his first application inAccess, and then migrated into Visual Basic and VB.NET, where hespecializes in creating applications for the Windows Mobileplatform. He worked for several software companies before forminghis consulting business in 2002, where he deals with all types ofclients including healthcare, financial, government, manufacturing,and small business. His ability to turn his customers' wishesinto working applications keeps them satisfied. Joe's alsowriting the fundamentals column for the Advisor Guide toMicrosoft Access magazine.
Alan Simpson is the author of over 100 computer books ondatabases, Windows, Web site design and development, programming,and networking. His books are published throughout the world inover a dozen languages and have millions of copies. Alan has alsotaught introductory and advanced computer programming courses atSan Diego State University and the UCSD Extension. He has served asa consultant on high-technology, educationoriented projects for theUnited States Navy and Air Force. Despite that, Alan has no fancyjob title because he has never had a real job.