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 __

Database Automation using VBA (Advanced Microsoft Access)1. Introduction to VBA 8 1.2 VBA Core Elements Notes: In VBA, objects also have methods. For example, a report object can be previewed or

  Object