Hello,
I am fairly new to macro's and VBA programming and do not know the difference between private sub and public sub (among a ton of other things).
My problem: I have a form with some buttons which all contain embedded macros. When I click these buttons, they execute a sequence of query's which are specified in the build-in macro expression tool. The query's are used to calculate some values from many tables.
Now I want to create a button in the same form that executes all the other buttons.
So my question is: How do I create a button which executes other buttons? I suspect this is done in VBA, but I do not know where to enter code or what code to enter.
I am fairly new to macro's and VBA programming and do not know the difference between private sub and public sub (among a ton of other things).
My problem: I have a form with some buttons which all contain embedded macros. When I click these buttons, they execute a sequence of query's which are specified in the build-in macro expression tool. The query's are used to calculate some values from many tables.
Now I want to create a button in the same form that executes all the other buttons.
So my question is: How do I create a button which executes other buttons? I suspect this is done in VBA, but I do not know where to enter code or what code to enter.