Diffrence between Macro & VB code

[wassimdaccache]

Hello everybody

I am using access 2007.

When I use button wizard option, access 2007 use macros to implement the action.

Meanwhile Access 2003 use VB code.

What is difference between them?" in terms of efficiency & speed..."

Which method is better to use ?

Is there any option in access 2007 that I am able to change it to tell the wizard method to use VB code in place of MACROS? "actually I feel comfortable using VB code"


Does MACRO do something on access applications that VB can't do it ?


THANK YOU IN ADVANCE & BEST REGARDS


WASSIM S DACCACHE

[hjozinovic]

There is option to convert macros to VBA code.
Look up access help for "convert macro"

[Krandor]

VBA code is much more powerful than macros. Macros are there basically for beginners who don't know how to code. You can do some simple steps (run a query or a report) and not too much else.

If you know VBA code, then stick with that and avoid macros altogether.

I'm a dba at work and I see a lot of homegrown applications (built by people who have some skills in Access but who are not db professionals). Almost 100% of the time I see almost no VBA code and extensive use of macros. When I see professionally created application the opposite is usually true.

[youmike]

For me, a compelling reason to use VBA rather than macros is the freedom that I then have to design error trapping, control of who uses what, and many other such needs to work just as I want. In VBA it is also much easier to design for later debugging.

When I started writing Access systems, around 15 years ago, I read all the expert advice I could find at the time and decided never to write a macro. The years since have shown me the wisdom of that decision for me.

Yes, it takes a little more effort in the earlier stages, but the later rewards are worth it.