In this post, we will be examining the VBA Editor and taking a look at its various facilities to aid with coding.

The VBA Editor is what we use to enter VBA code for Forms, Reports, custom functions and more. In fact all Microsoft Office applications (Word, Powerpoint, Excel, Outlook) use the same VBA Editor, so although we are learning to program with Access you will also be able to transfer ALL your skills and knowledge and even automate between applications.app-composer-icon-code-1024x1024

List of topics covered:

  • The VBA Editor, Converting Macros
  • The VBA Editor Explained
  • The Code Window
  • The Project Explorer Tree
  • The Properties Window
  • The Immediate Window
  • The Watch Window
  • How to select different Forms and Reports (from project explorer)
  • How to select different Modules
  • How to Rename Modules
  • Basic Tools for Writing Code
  • Naming Conventions
  • DoCmd Syntax and Arguments Explained
  • How to Convert a Standalone Macro
  • How to Convert a Form’s Embedded Macros
  • When to use Macros and VBA

Downloadable Content

Code Examples VBA Fundamentals

PDF

Videos

The VBA Editor

Break On Handled Errors

The Immediate Window

Related Posts

02 – Objects, Properties and Methods
03 – Data Types, Variables, Constants and Operators
04 – Events
05 – Functions, Sub-procedures And Arguments
06 – Debugging
07 – Conditionals And Branching
08 – Arrays And Collections
09 – Loops
10 – Recordsets

Leave a Reply

Your email address will not be published. Required fields are marked *

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube