Build VBA instead of MACRO

  • Thread starter Thread starter Chuck
  • Start date Start date
C

Chuck

A recent upgrade from Access 2003 to 2007 has left us with some questions
that we could usually find an answer for in the groups. However, this one
has us stumped. In Access 2003, when adding a command button to a form and
using the wizard, it would build the VBA code. The button properties could
then be edited in the OnClick event. Now, in Access 2007, the wizard builds
a macro and if any code needs to be written, the conversion from macro to
VBA has to be performed, each and every time a command button is added. Is
this the way Access 2007 is supposed to work now or is there an option that
we missed to build code and not use macros?
 
If you use the new file format (ACCDB), the wizard will generate an Embedded
Macro.

But if you use an MDB in Access 2007, the wizard will create VBA code.

So, unless you need something in the new file format (such as multi-valued
fields), you might be able to solve the issue by using an MDB.

(The reality is that the Wizard doesn't make very good VBA anyway.)
 
Back
Top