Macro V Event Procedures

[Guest]

Hi,

We have quite a large database which includes some 100 macros. I've been
looking into what they do and many of them just open reports or queries etc.
I was wondering wether it would be worth converting these to event
procedures. What it improve the performance of the database?

Regards

Ian

 

[Van T. Dinh]

VBA is more powerful and has error-trapping while the lack of error-trapping
is a major drawback for Macros. In addition, you can include most codes
related to a Form in the Form's Class module which helps eith the
encapsulation.

There are also Wizards that can help with coding, especially for learing
purposes.

OTOH, Macros are quick to write for simple stuff, especially for new users.

 

[Guest]

Thanks for the quick response, would you therefore recommend that I change
macros which simply run queries or reports over to VB code?

Does VB run quicker then macros?

Ian

 

[Van T. Dinh]

My guess is that for simple stuff, Macros actually run marginally quicker
since Macros are already compiled and possibly without the VBA overheads. I
doubt any user would observe the diference, though.

If you already have the Macros, leave them as they are ... When you need to
do complex stuff and / or manipulationg data by code, switch to VBA.

 

[Guest]

Many thanks.

Ian

My guess is that for simple stuff, Macros actually run marginally quicker
since Macros are already compiled and possibly without the VBA overheads. I
doubt any user would observe the diference, though.

If you already have the Macros, leave them as they are ... When you need to
do complex stuff and / or manipulationg data by code, switch to VBA.