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.

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