Access
®
™
About the Author
Richard Shepherd has worked for many years for major banks and corporations in the United Kingdom creating Access databases to solve specific problems. These companies include National Grid plc (electricity distribution), Hertz Car Leasing, NatWest plc (retail banking), Schroders plc (fund management), BNP Paribas (investment banking), Lloyds TSB plc (corporate banking), The Royal Bank of Scotland plc (investment banking), and the British National Health Service He has developed advanced databases for budgeting, business planning, trading reporting, and profit and loss reporting. He has qualified as an accountant with the Association of Chartered Certified Accountants and is now a Fellow of the Association. He is also the author of Excel VBA Macro Programming and Excel 2007 VBA Macro Programming (McGraw-Hill Professional). Richard works as a freelance software developer and can be contacted at tollside@yahoo.com.
About the Technical Editor
Allen G. Taylor is a 30-year veteran of the computer industry and the author of 27 books, including SQL for Dummies, Database Development for Dummies, and Crystal Reports 2008 for Dummies. He teaches database development through a leading online education provider, and lectures internationally on astronomy, history, innovation, and entrepreneurship. His blog address is www.moontube.wordpress.com, and his web site can be found at www.DatabaseCentral.Info. You can contact Allen at allen.taylor@ieee.org.
Microsoft Access 2010 VBA Macro Programming
®
™
Richard Shepherd
New York Chicago San Francisco Lisbon London Madrid Mexico City Milan New Delhi San Juan Seoul Singapore Sydney Toronto
Copyright © 2011 by The McGraw-Hill Companies. All rights reserved. Except as permitted under the United States Copyright Act of 1976, no part of this publication may be reproduced or distributed in any form or by any means, or stored in a database or