Visual Basic for Applications

Conventions

• Code Guide
• FAQ

Concepts

• Modules
• Classes
• Events
• Interfaces
• Convention over Configuration

Code

• Developer Tool Bar
• Array functions
• HTML
• XML
• Data Abstraction Layer
• Status

Problems and solutions

Double code execution

Problem

The function provided with the OnAction property is executed twice.

Solution

Put the function name in single quotes:

.OnAction="'functionname'"

Corrupt Microsoft Access database

Problem

Microsoft Access gives strange errors, when trying to compile the project.

Solution

Decompile your database