Teresa HennigRob CooperGeoffrey L. Griffith et al.John - Access 2010 Programmers Reference

Microsoft Access 2010 Programmer's Reference

Published by

Wiley Publishing, Inc.

10475 Crosspoint Boulevard

Indianapolis, IN 46256

www.wiley.com

Copyright 2010 by Teresa Hennig, Rob Cooper, Geoffrey Griffi th, Jerry Dennison

Published by Wiley Publishing, Inc., Indianapolis, Indiana

Published simultaneously in Canada

ISBN: 978-0-470-59166-6

No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted under Sections 107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization through payment of the appropriate per-copy fee to the Copyright Clearance Center, 222 Rosewood Drive, Danvers, MA 01923, (978) 750-8400, fax (978) 646-8600. Requests to the Publisher for permission should be addressed to the Permissions Department, John Wiley & Sons, Inc., 111 River Street, Hoboken, NJ 07030, (201) 748-6011, fax (201) 748-6008, or online at http://www.wiley.com/go/permissions.

Limit of Liability/Disclaimer of Warranty: The publisher and the author make no representations or warranties with respect to the accuracy or completeness of the contents of this work and specifi cally disclaim all warranties, including without limitation warranties of fi tness for a particular purpose. No warranty may be created or extended by sales or promotional materials. The advice and strategies contained herein may not be suitable for every situation. This work is sold with the understanding that the publisher is not engaged in rendering legal, accounting, or other professional services. If professional assistance is required, the services of a competent professional person should be sought. Neither the publisher nor the author shall be liable for damages arising herefrom. The fact that an organization or Web site is referred to in this work as a citation and/or a potential source of further information does not mean that the author or the publisher endorses the information the organization or Web site may provide or recommendations it may make. Further, readers should be aware that Internet Web sites listed in this work may have changed or disappeared between when this work was written and when it is read.

For general information on our other products and services please contact our Customer Care Department within the United States at (877) 762-2974, outside the United States at (317) 572-3993 or fax (317) 572-4002.

Wiley also publishes its books in a variety of electronic formats. Some content that appears in print may not be available in electronic books.

Library of Congress Control Number: 2010929738

Trademarks: Wiley, the Wiley logo, Wrox, the Wrox logo, Wrox Programmer to Programmer, and related trade dress are trademarks or registered trademarks of John Wiley & Sons, Inc. and/or its affi liates, in the United States and other countries, and may not be used without written permission. Microsoft and Access are registered trademarks of Microsoft Corporation in the United States and/or other countries. All other trademarks are the property of their respective owners.

Wiley Publishing, Inc. is not associated with any product or vendor mentioned in this book.

To my family and incredible friends, you help me to realize that every day is filled with precious momentssights, sounds, and emotions to be cherished. May we all remember to pause and savor the blessings that we have, especially the time that we share with those we love.

Teresa

To my family, for all of the love and support you've shown me over the years.

Rob

To my wife, Jamie, and my son, Ryan, I couldn't have been blessed with a better family and this would not have been possible without all of your love and support!

Geoff

To my wife Dianne, my son, Jeremy, my daughter, Amber, and my late parents, Clifford and Jeanette Dennison. You are my inspiration and my life. Thanks Dad, for instilling into me the insatiable appetite to explore and learn, without which I would not be where I am. To my grandchildren: Brianna, Fisher, and Huntlee. You are our future.

Jerry

Credits

Executive Editor

Robert Elliott

Project Editor

Tom Dinse

Contributing authors and Technical Editors

Ben Clothier

Doug (Dagi) Yudovich

Technical Editors

Dr. Jeff Boyce

Albert D. Kallal

Armen Stein

Contributors

Dane Miller

Garry Robinson

Steve Schapel

Larry Strange

Production Editor

Kathleen Wisor

Copy Editors

Nancy Rapoport

Paula Lowell

Editorial Director

Robyn B. Siesky

Editorial Manager

Mary Beth Wakefield

Marketing Manager

Ashley Zurcher

Production Manager

Tim Tate

Vice President and Executive Group Publisher

Richard Swadley

Vice President and Executive Publisher

Barry Pruett

Associate Publisher

Jim Minatel

Project Coordinator, Cover

Lynsey Stanford

Proofreader

Nancy Carrasco

Indexer

Robert Swanson

Cover Designer

Michael E. Trent

Cover Image

Randolph Jay Braun/istockphoto

About the Authors

Teresa Hennig loves challenges, solving problems, and making things happen. So it is no surprise that she was immediately hooked on Access; by its tools for rapid development and the ability to quickly create intuitive, user-friendly applications. Within a month, she started her own company as an Access developer and business consultant (1997). With a strong background in business and project management, Teresa (and her company, Data Dynamics NW), focuses on using Access to provide cost-effective custom database solutions. In recognition of her expertise and dedication to the Access community, Teresa has been awarded as a Microsoft Access MVP (Most Valuable Professional) every year since 2006. She continues to serve as President of both the Pacific Northwest Access Developers Group (PNWADG) and the Seattle Access Group. Her leadership, expertise, and service to the Access community have also earned her recognition as a National Community Champion from INETA. Being the lead author of several Access books has afforded Teresa the opportunity to work with esteemed colleagues and to invite others to share the experience of becoming published authors. Learn more at www.DataDynamicsNW.com and www.SeattleAccess.org.

Rob Cooper is a Senior Test Lead at Microsoft. He started at Microsoft as a support engineer in Charlotte, North Carolina in 1998 and joined the Access 2003 test team in Redmond in 2001. During the Access 2010 release, he led the team that worked on exciting new features such as the Macro Designer, Navigation Control, Web Browser Control, and the design and migration of objects for Access Services. He also helped test the 64-bit version of VBA in Office 2010 and programmability and security in Access 2010. He is currently working on Microsoft Bing. Rob has spoken at user group meetings and conferences such as the Portland Access User Group conference and Office DevCon in Brisbane, Australia, and has written for the Microsoft Knowledge Base. Aside from writing code in Access and C#, he also enjoys spending time with his family cooking, watching movies, going to the zoo and aquarium, and hanging out in and around Seattle.