Database Automation using VBA - ucb-access.org

← Back to document page

Database Automation using VBA UC BERKELEY EXTENSION MICHAEL KREMER, E-mail: Web Site: Copyright 2010 Michael Kremer All rights reserved. This publication, or any part thereof, may not reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying, recording, storing, or otherwise without express written permission. ICON KEY Note Example Warning 5th Edition Database Automation using VBA (Advanced microsoft Access) Page i TABLE OF CONTENTS 1. Introduction to VBA ______________________________________ 6 What is VBA? ________________________________________ _____ 6 VBA Core Elements ________________________________________ _ 7 Objects ________________________________________ ___________________ 7 Properties ________________________________________ _________________ 7 Methods ________________________________________ __________________ 7 Events ________________________________________ ____________________ 8 Variables ________________________________________ __________________ 8 VBA Program Structure _____________________________________ 9 Sub Procedure ________________________________________ ______________ 9 Function Procedure: ____________________

Database Automation using VBA (Advanced Microsoft Access) Page v 14.3 Word Mail Merge from Access _____ 268 14.4 Linked Table Verification Process _____ 271

  Microsoft, Words