Acc2007 VBA vs Macro

[Guest]

Is there any way to change the default for Access 2007 (creating ACC2000
files) to not create Macros but create VBA script as it used to?

I am trying to make buttons and lookup combo boxes and used to find it very
convenient to use the wizard to get the basic script done for me. Now it
makes macros attached to the events. I thought those were on their way out?

Any way I can change it back?

Thanks

 

[Jeff Conrad]

Hi Inky,

No, there is no way to change this back in 2007 as far as I know.

Microsoft is making a bug push with macros in this upcoming version so they are definitely not going
away. MS is trying to make "safe" macros with their wizards as a way to make the databases run
properly even under non-trusted locations.

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

in message:

 

[Guest]

That's unfortunate. I wish I had known that years ago, then I would have
continued to use macros, now it will be quite a hassle to get back into the
swing of those things.

Inky

 

[Jeff Conrad]

Hi Inky,

Although an understanding of macros is always a good thing, especially when using Access 2007, there
are many things that macros simply cannot do. In that regard you should not abandon your study and
use of VBA.

In 2007 MS has made some improvements in macros. Specifically, they have added the ability to handle
errors now which was not possible in any previous versions of the product. With Embedded Macros (new
in 2007), one nice advantage is that copying and pasting controls brings across the Embedded Macro
as well. If you had a command button that had a click event with VBA and copied that command button
to another form, the code would not come with it. With an Embedded Macro, the click event macro
would come with it. Similarly, if you deleted a command button that had VBA code with it, the code
would not be deleted. If you use an Embedded Macro, the macro would be deleted as well.

With 2007 (and other versions as well) you simply need to decide in which case you want to use a
macro or VBA. Each has their place.

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

in message: