MS Access 2007 - Use Control Wizard

[JohnG]

In the past versions of MS Access, when creating a button on a form, with the
Use Control Wizard button enabled, VBA code was written. Apparently, Access
2007 automatically creates macros instead. Is there a way to revert back to
creating VBA code when creating a button with the Control Wizards enabled? I
have checked the Access Options, and maybe I missed it, but I did not find
any reference to this feature.

 

[Jeanette Cunningham]

Hi JohnG,
the short answer is no.
There is a way to convert macros to code - you may be able to do that.
On the nav pane, choose a macro.
On the ribbon choose database options, then choose macro, convert macro to
code.
I haven't tried this, so I can't say what the code looks like after
converting.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Steve Schapel]

John,

The control wizards create Embedded Macros, which are new to Access 2007.

 

[Steve Schapel]

Jeanette,

You can use the facility you mentioned to "convert" all a form's macros in
one hit. So that has some appeal.

But the code does not come out as you or I would write the code. It is
often clumsy and ugly. And in the case of complex macros, the converter
sometimes just can't cope.

 

[Jeanette Cunningham]

Thanks Steve for that info.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia