Difference between revisions of "Visual Basic for Applications"

From vb24
Jump to navigation Jump to search
Line 29: Line 29:
 
.OnAction="'functionname'"
 
.OnAction="'functionname'"
 
</syntaxhighlight>
 
</syntaxhighlight>
 +
 +
=== Corrupt Microsoft Access database ===
 +
;Problem
 +
:Microsoft Access gives strange errors, when trying to compile the project.
 +
;Solution
 +
:[[Decompile Microsoft Access Database|Decompile your database]]

Revision as of 01:29, 21 March 2016

General

Conventions

Concepts

Code

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