View Full Version : Macros to Create Menu Items


bassman71
02-09-2007, 05:52 PM
Hello,
I've recently been assigned to tinker under the hood of an existing Access 2003 db. This db is layered with macros that call other macros within a complex set of Add Menus/Run Macros/sub routines that makes my brain cry uncle.

Being an Excel guy, I've created menu classes as .xla enhancements and this seems like a more robust and ultimately simpler solution, especially when it comes to debugging. Furthermore, I've always read to keep clear of macro usage in Access.

My question: Is there a better way to create menu items in Access?

Thanks much..........bassman