VBA or Macros

[mastromb]

I am building my database base on a template I got off of the Microsoft Access Website and it includes a combination of embedded macros and event procedures, VBA.



At this point I am not having too much problem editing either to get what I need to done, but that does not mean that I understand either very well at this time. However I am really trying to think about this database from a macro point of view and do things the right way the first time and not just what works just for the moment. I want to plan for this database to be upscaleable and to probably work on a network which may mean that the backend will reside on an SQL server. I am trying to learn and understand VBA, which I will take any reference recommendations on, but at this point both VBA & Macros are just greek to me.

So the question is should I be trying to convert all of the embedded macros to VBA or visa versa? Or is everything OK the way it is and if it ain't broke don't fix? What are your thoughts?

[RuralGuy]

Microsoft promotes macros in its samples and templates. My preference is code because I feel I have more control of the machine. I believe you will find more developers prefer code but that might be because they started with code. The choice is really yours.

[mastromb]

Would you recommend that I work on learning how to convert the Macros to Code as I move forward with this DB or just let sleeping dogs lie and create all new reoutines in Code? Any reference recommendations, I would rather not continue to be a constant leach of other peoples knowledge?

[RuralGuy]

Converting macros to code in ac2007 is pretty straight forward.

[mastromb]

I guess it doesn't get any easier than that!!

[RuralGuy]

Have fun. Are you ready to follow the link in my sig to mark this thread as Solved?

[Rainlover]

In Office 2010, Access is capable of being used on the Net. However you must use Macros and not Code.

So I guess it is a good idea to learn both. But for me I will stick with code and 2003. As RG said, you have more control.