01 – The VBA Editor

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

As always, a site wouldn't be anything without its users so please feel free to comment! We welcome any comments you have on the material and any suggestions you may have for future content.


In our humble opinion, it is worth commenting just so you can play with Fun Captcha below!

Leave a Reply

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