Macroes vs VBA in Button Wizard
When using the Button wizard MS Access creates macroes as default. This should be an option if you prefeer macroes or vb as the event code.

10 comments
-
Anonymous commented
Let's dump macros altogether and just use VB only. Let's make Access itself smaller.
-
Heinz Hoegel commented
...and by the way, there is absolutely no technical reason for not providing an option to choose between the macro and the VBA wizard. They are both still there. If you work in an old MDB database, the default for the wizard is still VBA!
-
Heinz Hoegel commented
KVD is right, this is just another example of how the Access team is ticking, ignoring consequently any input from real developers from the real world they are working in. Wishful thinking by MS is no replacement for listing to the customers and developers!
-
Rob commented
What's the status on this? I use 2010, 13 and 16. For sure on 16 i have the "always use event procedures" checked and it "always generates a macro" in the wizard. Very annoying for me.
-
Dick Burgers commented
Thanks @Anders, you made me happy as well ;-)) ) I was not aware of this option :-))
-
KVD commented
This is the classic MS Team saying we will change your default and not publish a way out - as it happens the way out does not work either. "You will eat your vegetables whether you like it or not."
If the Access Team thinks macros are so much better that VBA code, then defend it by publishing why. And be prepared to be convinced otherwise. Please LISTEN to us and stop jerking the rug out from under our feet. Each time you (the team) change a default, tell us where and why.
-
Anders Ebro (TheSmileyCoder) commented
Ah sorry. I use that button to default to use event code, but not, it doesn't use the wizard to create the code for me. When I press the button (in 2010) it takes me to the code window, instead of opening the macro window.
-
PSH commented
Seem like i was a little fast here. Even after restarting the application it stills creates a Macro.
Did a fast search and it seem like they removed the support for auto creating VBA
https://social.msdn.microsoft.com/Forums/office/en-US/085f54f4-870e-4c3b-bd4b-b095b12d45c1/always-use-event-procedures-not-working -
PSH commented
Thanks for the reply you are absolutely right :-)
-
Anders Ebro (TheSmileyCoder) commented
Your in luck!
This feature is already there. I can tell you where to find it in Access 2010.
Click File
Click Options
Select Object Designers
Scroll down a bit to Form/Report Design view
Check the box "Always Use Event Procedures"Hope that helps
Anders Ebro // TheSmileyCoder
Access MVP
www.TheSmileyCoder.com