items in module

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a handy way to print out the functions and subs in a module? I find
myself constantly looking for which global module has the particular function
I am looking for. I just want a list of what functions are in a module, not
the code.
Thanks so much
 
smk23 said:
Is there a handy way to print out the functions and subs in a module? I find
myself constantly looking for which global module has the particular function
I am looking for. I just want a list of what functions are in a module, not
the code.
Thanks so much
Click to expand...

While I don't know the answer to your question you can type the function you
want to find in the immediate window, position the cursor back into the name,
and then press <Ctl F2> and Access will take you to it wherever it is.
 
great! That helps

Rick Brandt said:
While I don't know the answer to your question you can type the function you
want to find in the immediate window, position the cursor back into the name,
and then press <Ctl F2> and Access will take you to it wherever it is.
Click to expand...
 
smk23 said:
Is there a handy way to print out the functions and subs in a module? I find
myself constantly looking for which global module has the particular function
I am looking for. I just want a list of what functions are in a module, not
the code.
Click to expand...


Yes, there is a way to do that. It may be tedious, but it's
not too difficult to code a procedure that loops through the
Modules collection and uses the various methods of the
module object to find the procedures.

For your stated goal, what Rick suggested is far superior,
but if you want to pursue doing it yourself, post back with
questions about a specific aspect that's giving you trouble.
 
Back
Top