Change macro to visual basic code.

[Guest]

The way i was taught to run database menus was to create loads of macros.
E.g. macro to close switchboard and open applications menu then to get back
to switchboard the command button runs a macro which says close applications
menu open switchboard and i have this for all menus and forms.

When i click on the performance analyzer tool it tells me to change these
macros to visual basic code - how do i do this?

 

[Steve Schapel]

Database User,

The performance analyzer always says this about any macro, so in other
words it is basically meaningless. In most cases, macros do not perform
worse than VBA code.

There is also a facility to "convert" macro to code. This is accessed
under the Tools|Macro menu from the main database menubar. However, I
would personally not recommend this. Like all wizard-produced code, the
VBA code thus produced is always ugly and awkward, and in the case of
some complex macros it just can't manage. I think if you want macros,
use macros, and if you want VBA, write VBA.

 

[Guest]

Steve,

I should have read this first. I just completed a project and coverted all
my macros to VBA in Office 2007. Now none of my buttons work and I have a ton
of them. What happened? what can I do to get them either back to macros or to
get them to work the way they did when they were macros.
Thanks for your help!