Hi all,
A colleague posed a question to me regarding macros. I told him what I thought, but I am by no means an expert on macros (I never use them). He has inherited an Access database which is chock full of forms, controls and other cute GUI stuff. There are also a bunch of macros. He asked me if there was a way to document all the places where a macro is triggered, without performing the tedious task of going through the properties of every single control. Is there a simpler way? We know that he can search the VB for the macro name, but not all of the controls have VB code associated to them. Any ideas would be great!
Thanks
Kelly
A colleague posed a question to me regarding macros. I told him what I thought, but I am by no means an expert on macros (I never use them). He has inherited an Access database which is chock full of forms, controls and other cute GUI stuff. There are also a bunch of macros. He asked me if there was a way to document all the places where a macro is triggered, without performing the tedious task of going through the properties of every single control. Is there a simpler way? We know that he can search the VB for the macro name, but not all of the controls have VB code associated to them. Any ideas would be great!
Thanks
Kelly
