List of Subs and Functions within Access

[AlanAnderson]

Hi All,

I'm thinking of creating a central store of routines used in my various programmes.

Does anyone out there have a routine in Access that will look through several other Access programmes (even one by one) and make a list of what subs and functions exist and where they are (Mdb name, Module, Form etc.)

Regards,

Alan

 

[mdlueck]

I used this MS sample code:

Displaying a List of All VBA Procedures in an Excel 2007 Workbook from the Ribbon (June 2009)
http://msdn.microsoft.com/en-us/library/office/dd890502(v=office.11).aspx

To produce my Excel 2007 VBA Lines of Code (LOC) counter. Its default behavior was to scan all VBA code for label names and document its output to a GUI form.

I adjusted it to be a LOC counter, my solution based on this code is found here:

CountLines for Excel
http://www.access-programmers.co.uk/forums/showthread.php?t=237998

 

[AlanAnderson]

Thanks Michael,

I will check this out to see if it can be adapted for Access.

Thanks,

Alan

 

[mdlueck]

Alan, be sure to also review Allen Browne's code which I reference in my code. It already enumerates through all Access VBA code, so just harvest the function/subroutine detector logic out of the MS post, and you should be there shortly.