What is this book about? Its power and short learning curve have made Access Microsoft’s leading consumer relational database management system for desktop applications. VBA lets you tap more of that power, responding to application level events, displaying forms and reports, manipulating toolbars, and much more. In this book, a crack team of programmers, including two Microsoft MVPs, shows you how to take control of Access 2003 or 2002 using VBA. You’ll learn to create and name variables, use DAO and ADO to manipulate data, handle errors correctly, create classes and use APIs, and more. An entire chapter is devoted to the changes in Access 2003, including new wizards and GUI features that previously required VBA code as well as new VBA features. You’ll receive a thorough education in system security, macro security, and the Access Developer Extensions (ADE). You will discover how to access data with VBA, execute and debug VBA code, and use VBA with Access objects. Finally, you will learn more about the relationship between Access and SQL Server, and how to use VBA in Access to control and enhance other Office applications. What does this book cover? Here are some of the things you'll discover in this book: How to take advantage of the built-in Access object library, using Access commands and executing them from any Access toolbar What you need to know to design your own classes, implement common APIs in your code, and use SQL to access data How to configure custom menus for your Access database applications Ways to transfer information between Access and Excel, Word, Outlook, and other Office programs How to show or hide entire sections of reports based on data entered on a form, or hide form fields based on database login information Object models you can use when writing VBA code in Access, and a list of common API functions to use in your code Who is this book for? This book is a comprehensive resource for Access users and VBA developers who want to increase the power of Access using VBA. In addition to experience with VBA, you should have read at least one tutorial covering VBA for Access.

What is this book about? Excel 2003 VBA Programmer's Reference is an updated and expanded version of the two previous editions now with a reference section downloadable from the Web for easy perusal. The book is aimed at Excel users who want to gain more control over their spreadsheets using VBA or who want to develop Excel applications for other users. The book starts with a primer chapter focused on bringing the readers up to speed with Excel and VBA. From there, the book expands to focus on major issues faced by advanced Excel users and developers. What does this book cover? In this book, you'll discover how to do the following: Set up applications and convert them to add-ins Package and distribute Excel applications Set up interaction with other Office applications and databases Program the VB Editor and use the Windows API Use VB6 and VB.NET with Excel Set up internationalization Advanced debugging and error handling techniques

* As part of the Power Pack family of books, this book gives programmers and advanced Access users the knowledge they need to master the power within Access-the world's most widely used database management system * Shows how to use VBA to design efficient, user-friendly end-user applications in Access * Starts with database concepts and event-driven programming, then covers VBA programming fundamentals, the Visual Basic Editor, VBA language elements, and code debugging * Covers advanced Access programming techniques like connecting to databases with ADO and interacting with other applications * Includes helpful discussions on compatibility issues and manipulating Visual Basic components * Companion Web site includes all the code examples in the book

Proven techniques that maximize media exposure for your business A seasoned PR pro shows you how to get people talking When it comes to public relations, nothing beats good word of mouth. Want to get customers talking? This friendly guide combines the best practical tools with insight and flair to provide guidance on every aspect of PR, so you can launch a full-throttle campaign that'll generate buzz -- and build your bottom line. Discover how to * Map a winning PR strategy * Grab attention with press releases, interviews, and events * Cultivate good media relations * Get print, TV, radio, and Internet coverage * Manage a PR crisis

From differentiation to integration - solve problems with ease Got a grasp on the terms and concepts you need to know, but get lost halfway through a problem or, worse yet, not know where to begin? Have no fear! This hands-on guide focuses on helping you solve the many types of calculus problems you encounter in a focused, step-by-step manner. With just enough refresher explanations before each set of problems, you'll sharpen your skills and improve your performance. You'll see how to work with limits, continuity, curve-sketching, natural logarithms, derivatives, integrals, infinite series, and more! 100s of Problems! Step-by-step answer sets clearly identify where you went wrong (or right) with a problem The inside scoop on calculus shortcuts and strategies Know where to begin and how to solve the most common problems Use calculus in practical applications with confidence

Apply important legal concepts and skills you need to succeed Get educated, land a job, and start making money now! Want a new career as a paralegal but don't know where to start? Relax! Paralegal Career For Dummies is the practical, hands-on guide to all the basics -- from getting certified to landing a job and getting ahead. Inside, you'll find all the tools you need to succeed, including a CD packed with sample memos, forms, letters, and more! Discover how to * Secure your ideal paralegal position * Pick the right area of the law for you * Prepare documents for litigation * Conduct legal research * Manage a typical law office Sample resumes, letters, forms, legal documents, and links to online legal resources. Please see the CD-ROM appendix for details and complete system requirements.

An accessible guide to the wonders of the night sky, now updated From asteroids to black holes, from quasars to white dwarfs, this new edition of Astronomy For Dummies takes backyard stargazers on a grand tour of the universe. Featuring star maps, charts, gorgeous full-color photographs, and easy-to-follow explanations, this fact-filled guide gives readers a leg up on the basic principles of astronomy and shows how to get the most out of binoculars, telescopes, planetarium visits, and other fun astronomical activities. This updated edition includes an updated color signature and covers the many discoveries made in recent years, as well as new astronomy Web sites.

Let the adventure begin with this straightforward guide to GURPS! This is it—the key that unlocks the riches of GURPS (Generic Universal Role Playing System) and gives you a wealth of information on how to create your character and fine-tune your play. Produced in partnership with Steve Jackson Games, the game's creator, GURPS For Dummies is the ideal companion to GURPS Basic Set, 4th Edition that explains the rules. It gives you insight into the choices you’ll make in everything from creating a fun, dynamic character using the allotted number of points, to playing in an adventure, to becoming a GM. Whether you want to be an Amazon princess or a stalwart warrior, an old-fashioned swashbuckler or a modern investigator, a tough cop or a cat burglar, a sorcerer casting spells or a cosmic ranger, fighting lawlessness in the asteroids, this guide will help you: Determine your character’s basic attributes: IQ, DX (dexterity), ST (strength) and HT (health) Figure out your character’s secondary characteristics Choose advantages (including powers and perks) and disadvantages (including quirks and disadvantages with a self-control roll modifier) Optimize your points by using talents Select your skills based on functional area or the campaign setting Enhance your character with spells, magic items, magic staves, and powerstones Strategically purchase equipment for different characters, tech levels, and campaign types Create and manage a character sheet, write a character background, keep a character log, and more—all with samples Choose good combat techniques and play with your character If you want to become a GM, this guide gets you going with advice on creating the adventure, managing the character creation process, managing combat, and interpreting the rules. There’s even a handy Cheat Sheet tear-out GM screen in the front of the book. There are tips throughout, plus advice on how to: Create your very own GURPS universe for your campaign, whether it’s dungeon-crawl, high-adventure, combat-focused, puzzle-focused, or masquerade-type Provide a basic write-up of the world for your players, including technology level, supernatural and supernormal abilities and powers, races, setting, character templates, cultural and social information, and limitations Create an electronic combat grid, a battle log, a tactical map, and more—with samples Do mapping, planning, and plotting Create memorable NPC (nonplayer characters), both good guys and bad guys GURPS For Dummies helps you create more detailed, exciting, and interesting characters and take your game to the next level. That’s important whether you’re saving a princess or saving the planet…searching for hidden treasure or for secrets to eliminate disease… fighting crime or combating armies of evil robots…casting spells in medieval castles or destroying terrorist cells in modern day milieus. With GURPS, the only limitation is your imagination.

From identifying your needs to exploring your options -- make the right career move Changing careers by choice or due to circumstances beyond your control? Have no fear -- this hands-on guide focuses on helping you find a new job, start a business, or return to school in a detailed, step-by-step manner. With concise, eye-opening self-assessments, you'll understand how to assess your current situation, explore various career ideas, and identify ways to utilize your talents and skills in jobs that suit your lifestyle. You'll see how to build a career that lets you express who you are, fulfill your needs and desires, and live the life you want! Discover * Detailed, to-the-point explanations on outlining your action plan * The inside scoop on transforming your passions into career options * A wealth of tips, tricks, and warnings * How to blend your ideal career with the realities of your life

How to enjoy a day at the races-and bet to win! The last two years have seen a record number of Americans tune in for climatic Triple Crown races featuring Smarty Jones and Funny Cide; in 2004, television viewership jumped a whopping 61 percent over the record set in 2003, and the Belmont Stakes race itself drew a record crowd of more than 120,000! This easy-to-understand guide shows first-time visitors to the track how to enjoy the sport of horse racing-and make smart bets. It explains: what goes on at the track what to look for in horses and jockeys how to read a racing form and do simple handicapping how to manage betting funds and make wagers that stand a good chance of paying off. Complete with coverage of off-track and online betting, it's just what anyone needs to play the ponies-and win! Richard Eng (Las Vegas, NV) is a racing writer and handicapper for the Las Vegas Review-Journal, a columnist for the Daily Racing Form, and the host of a horseracing radio program in Las Vegas. He was formerly a part of the ABC Sports team that covered the Triple Crown.