Embeded Macros or Events

[PhilOfWalton]

I have been helping some people on this forum with their Access problems, and find some of them are using Embedded Macros as well as Event Procedures on their forms.

I have always used Event Procedures. In fact the only Macros I use are AutoExec & occasionally Autokeys.

I appreciate that Embedded macros may be easier to write, but for the finished product have they any advantages / disadvantages against Event Procedures?

What happens if you upsize your Db. Are there different problems with say SQL server or Silverlight and Web applications?

Hope this doesn't open up too big a can of worms, but I would be interested in the other experts' views.

Thanks

Phil

[ADezii]

I occasionally use an AutoExec Macro, and rarely, an Autokeys Macro. On every other occasion, I use Event Procedures.

[PhilOfWalton]

Thanks, I appreciate that, but I am trying to establish if there is any point in having Embedded Macros.

In the same way I have a pet hatred of lookup tables, and see no point in those either.

Phil

[jforbes]

I find it easiest to know as few languages as possible. So I try to stick with Visual Basic when it's available, and it's available a lot:

• Visual Basic for Application - In pretty much all Office applications as well as a few others, including AutoCAD.
• VB.NET - Winforms, ASP.NET, Webservices (WCF), WPF, COM.
• VB Script - Basic Scripting as well as a language in quite a few ERP systems.
• SQL CLR

I currently maintain two applications that have a common library with one library in VBA (Access) and another in VB.NET. Porting this code back and forth would be much more difficult if they weren't both in Visual Basic.


Specifically, for the selection between VBA or Macros for Event Procedures, I prefer all the code in one place where it is searchable and easily diffed.

I can't think of any reason that Macros would cause difficulty when upsizing since, you will still have a Front End Database where the Macros can execute just as they do now. Data Macros would need to be converted to Triggers, but that is an all around improvement.