Why Macros?

[NaKin]

I was wondering why one would use a macro instead of VB. I've never used a macro yet in Access and was wondering if I was missing something.

Thanks for any info,

 

[Mile-O]

I was wondering why one would use a macro instead of VB.

They don't know VBA, don't want to know VBA, or are extremely new to Access and either don't know about VBA or are put off by having to learn the language.

Macros are poor in relation to VBA code. They offer little functionality, little flexibility, and provide no means of error trapping so, should a macro fail, it fails visibly; at least with code you can catch an error and deal with it without the user ever knowing.

Go with VBA.

 

[NaKin]

Thanks Mile-O, it's what I suspected but it's nice to know I'm not missing out on something important.

 

[tacieslik]

One thing I would like to mention. I'm trying to learn the VBA side of Access 2K and often I find it quite usful to create a macro and then save it as VBA code. Sometimes I know what macro to use, but I don't know the code. However, as macros are not as useful, there soon comes a time when this 'procedure' is not.

Worth a mention though!

Regards,