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: ________________________________________ _________ 9 Standard M

Database Automation using VBA (Advanced Microsoft Access) Page ii 3.2 Decision Structures _____ 36 If Statement _____ 37

  Access, Microsoft, Microsoft access