Recent content by MeyerForHire

(SOLVED) Access vba Get Macro Properties and Comments Okay, I figured it out! I printed Access' documenter for my AutoExec macro and the description was in the report. That told me it surely had to be possible to get those properties. I noticed that 'Container' was also listed in the report...

Yeah, I edited that out of my original post. I have been able to distill the Actions, Arguments, and Comments from the macros using the below: For all those interested.... Start with a piece of code like this: For Each accobj In CurrentProject.AllMacros 'Debug.Print accObj.Name...

[SOLVED] Access vba Get Macro Properties and Comments Hello All, First time poster, long time user. Using Access 2007: Does anyone know how to get macro properties using vba? I've attempted something similar to the below to try and divine macro properties: Sub MacroDiscovery() Dim mcr...