How do I obtain a list of functions/subs in modules?

[jrbarnett]

Hi,

I am writing an Access 97 addin to document databases and wondered if anybody can think of an easier way of obtaining the function/sub prototypes in each module without parsing each line of the module code in the Modules collection.
This information is available in the Object browser so it is obviously available.

Regards

John

 

[JGillespie]

Look in Access 97 help under Module. If you look at the properties of the Module object you should find an example of a function that does pretty much what you need, the only thing you need to add is a loop to go through all modules rather than just one. Jamie Gillespie
j-gillespie@s-cheshire.ac.uk