Module is an object in desktop databases containing custom procedures that you code using Visual Basic. Modules provide a more discrete flow of actions and allow you to trap errors.
Everything that can be done in a macro can also be done in a module, but you don't get the macro interface that prompts you what is needed for each action.
Modules are far more powerful, and are essential if you plan to write code for a multi-user environment, because macros cannot include error handling.
Modules can be standalone objects containing functions that can be called from anywhere in your application, or they can be directly associated with a form or a report to respond to events on the associated form or report.
Everything that can be done in a macro can also be done in a module, but you don't get the macro interface that prompts you what is needed for each action.
Modules are far more powerful, and are essential if you plan to write code for a multi-user environment, because macros cannot include error handling.
Modules can be standalone objects containing functions that can be called from anywhere in your application, or they can be directly associated with a form or a report to respond to events on the associated form or report.
0 Comments