Microsoft Access Vba Programming For The Absolute Beginner

Microsoft Access VBA Programming for the Absolute Beginner ® Second Edition MICHAEL VINE © 2005 by Thomson Course Technology PTR. All rights reserved. No part of this book may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying, recording, or by any information storage or retrieval system without written permission from Thomson Course Technology PTR, except for the inclusion of brief quotations in a review. Publisher and GM of Course PTR: Stacy L. Hiquet Associate Director of Marketing: Sarah O’Donnell Marketing g Manager: Heather Hurley The Premier Press and Thomson Course Technology PTR logo and related trade dress are trademarks of Thomson Course Technology PTR and may not be used without written permission. Manager of Editorial Services: Heather Talbot Microsoft and Access 2003 are registered trademarks of Microsoft Corporation in the United States and/or other countries. Acquisitions Editor: Mitzi Koontz All other trademarks are the property of their respective owners. Senior Editor: Mark Garvey Important: Thomson Course Technology PTR cannot provide software support. Please contact the appropriate software manufacturer’s technical support line or Web site for assistance. Thomson Course Technology PTR and the author have attempted throughout this book to distinguish proprietary trademarks from descriptive terms by following the capitalization style used by the manufacturer. Information contained in this book has been obtained by Thomson Course Technology PTR from sources believed to be reliable. However, because of the possibility of human or mechanical error by our sources, Thomson Course Technology PTR, or others, the Publisher does not guarantee the accuracy, adequacy, or completeness of any information and is not responsible for any errors or omissions or the results obtained from use of such information. Readers should be particularly aware of the fact that the Internet is an ever-changing entity. Some facts may have changed since this book went to press. Marketing Coordinator: Jordan Casey Project Editor: Scott Harris/Argosy Publishing Technical Reviewer: Eric Olson PTR Editorial Services Coordinator: Elizabeth Furbish Copy Editor: Tonya Cupp Interior Layout Tech: Shawn Morningstar Cover Designer: Mike Tanamachi Educational facilities, companies, and organizations interested in multiple copies or licensing of this book should contact the publisher for quantity discount information. Training manuals, CD-ROMs, and portions of this book are also available individually or can be tailored for specific needs. CD-ROM Producer: Keith Davenport ISBN: 1-59200-723-6 Library of Congress Catalog Card Number: 2004114910 Printed in the United States of America 05 06 07 08 09 BH 10 9 8 7 6 5 4 3 2 1 Proofreader: Jan Cocker Thomson Course Technology PTR, a division of Thomson Course Technology 25 Thomson Place Boston, MA 02210 http://www.courseptr.com Indexer: Nancy Fulton Acknowledgments W riting any book is not easy, especially a technical programming book. It takes many great, patient, and talented people to write, edit, design, market, finance, and produce a book and accompanying CD-ROM. Without the publishing assistance of Mitzi Koontz, Scott Harris, and Tonya Cupp, it would be impossible for me to share with you my knowledge of programming in such a professional and fun manner. I’d like to thank a good friend, Eric Olson, who ensured the technical accuracy of this book. Thanks Eric! Now that the book is done, let’s go fishing! Beyond the technical and business workings of creating a book, the Author must be fed, loved, and encouraged. Without the support of my beautiful wife Sheila, this would never have happened.