VBA vs Macros: Which one?

[satty]

hey people,

one more thing. i have tried to seatch the net for just about anything on this but am being a little unsuccessful. can anyone tell me whether i should use VBA Code or Macros to open and close forms as well as navigating through records etc.

i have been advised by tutor handouts to use macros, however i am finding VBA is alot 'tidy'r' if ya know what i mean.

what are the advantages / disadvantages of macros vs VBA?
or if anyone knows of any websites with this kind of information, this would be very useful!

thanx people!!!


Satty

 

[Mudface]

Whatever's easiest for you, really. VBA code is much more flexible than macros but equally can be much more complicated. It might be worthwhile if you're just starting with Access to develop a few Macro procedures, then convert them to VBA. This would give you the correct syntax and provide an easy introduction to using VBA code.

 

[CT Witter]

Also remember that macros have limited error trapping/handling. To develop "robust" solutions you may need to convert macros to vba.

HTH,
CT

 

[mdmilner]

Whatever is easiest at first - then if you need something 'more' you will pretty much have to go to VBA.

Why not use the Form Button Wizards to handle things though?
When you create buttons, by default, a wizard opens that actually writes VBA into the click event to do the action -- and the available options handle all of the things you explicitly listed in your message plus more.

Mike