Access 2007 VBA Bible

If you've been using Access for a while, you're probably aware of its power and potential and itching to take advantage of both. Access2007 VBA Programming For Dummies takes you beyond forms and reports and shows you how to use VBA to create killer Access databases and applications. This gentle introduction to VBA programming covers everything you need to get started, including:Basic programming skills and conceptsExplanations of modules, procedures, objects, and argumentsAccess-unique programming activities, including SQL and recordsetsHow to use the Visual Basic editorCreating dialog boxes, lists, drop-down menus, and functionsIntegrating with other Office applicationsReady-to-use VBA code examples to type in or copy and paste from the WebCompletel...

"I recommend this book for anyone who wants a strong foundation in Access."Jeff Lenamon, CIBC World MarketsUpdated edition with exciting new Access 2007 features!Harness the power of Access 2007 with the expert guidance in this comprehensive reference. Beginners will appreciate the thorough attention to database fundamentals and terminology. Experienced users can jump right into Access 2007 enhancements like the all-new user interface and wider use of XML and Web services. Each of the book's six parts thoroughly focuses on key elements in a logical sequence, so you have what you need, when you need it. Designed as both a reference and a tutorial, Access 2007 Bible is a powerful tool for developers needing to make the most of the new feature...

Step-by-step instructions for creating VBA macrosHarness the power of VBA and create custom Excel applicationsMake Excel 2007 work for you! This clear, nonintimidating guide shows you how to use VBA to create Excel apps that look and work the way you want. Packed with plenty of sample programs, it explains how to work with range objects, control program flow, develop custom dialog boxes, create custom toolbars and menus, and much more.Discover how to* Grasp essential programming concepts* Use the Visual Basic(r) Editor* Navigate the new Excel user interface* Communicate with your users* Deal with errors and bugs...