Procedure Names

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mrcasey - 07 Apr 2005 15:21 GMT

Does anyone know how I can create code to give me the names of all procedures
in a database (from all types of modules)? Is there something similar to
getting the names for other types of objects, ie tables, queries,
modules,etc.?

Reply to this Message

Paul Overway - 07 Apr 2005 16:51 GMT

You'd have to write code to iterate through Modules, then iterate through
each line in the module and use ProcOfLine to get the
name of the procedure. To make the routine faster, once you have a
procedure name, you could move to the end of that procedure vs to the next
line by using ProcCountLines.

You'll also have to interate through the Form and Report Document
containers, open each document, determine if it has a module, open the
module, and then iterate through each line similar to above.

Writing a procedure to accomplish this would be somewhat involved, but
reading the help topics for some of the functions mentioned above should get
you headed in the right direction. There are commercial products available
like Total Access Analyzer that would do this also.

Signature

Paul Overway
Logico Solutions
http://www.logico-solutions.com

> Does anyone know how I can create code to give me the names of all
> procedures
> in a database (from all types of modules)? Is there something similar to
> getting the names for other types of objects, ie tables, queries,
> modules,etc.?

Reply to this Message

Jeff Conrad - 07 Apr 2005 17:07 GMT

> Does anyone know how I can create code to give me the names of all procedures
> in a database (from all types of modules)? Is there something similar to
> getting the names for other types of objects, ie tables, queries,
> modules,etc.?

For the second part of your question you can use my "Doug Steele Object
Documentor" add-in for Access that will do this. It will create a report in
your database that lists all of the objects in an easy-to-read format. You
can find the free add-in on Doug's site here:

http://www.accessmvp.com/djsteele/Documentor.html

For the first question.....hummmm.....that sounds like an interesting
challenge. I think I'll add that to my "To-Do" list.

Signature

Jeff Conrad
Access Junkie
Bend, Oregon

Reply to this Message

Jeff Conrad - 09 Apr 2005 20:47 GMT

Mrcasey,

I have completed creating an Access Add-in that will generate a report that lists all of the
procedures names from every form, report, and module. It will, of course, skip any objects that have
their HasModule property set to No.

The report first groups by object type, then by each object name alphabetically. The procedure names
are also listed alphabetically. The report also will give a count of the procedures in each object,
a count of the number of code-bearing
objects for each category, and a total number of procedures.

It is called the "Jeff Conrad Procedure List" Add-in for Access.
Cool name, huh? ;-)
What???

I have one version for Access 97 and one 2000 version that works with 2000, 2002, and 2003. Before
releasing to the masses, I would like to make up a User Guide like my other add-ins and do some
extensive testing. However, if you would like to take it for a test drive and give me some feedback,
I would be happy to send along a copy.

Post back here and let me know if you are interested.

Signature

Jeff Conrad
Access Junkie
Bend, Oregon

> > Does anyone know how I can create code to give me the names of all procedures
> > in a database (from all types of modules)? Is there something similar to
[quoted text clipped - 10 lines]
> For the first question.....hummmm.....that sounds like an interesting
> challenge. I think I'll add that to my "To-Do" list.

Reply to this Message

Rev - 17 Sep 2005 21:35 GMT

Hi Jeff, Greetings from San Clemente, CA

I am currently developing a suite of Access add-in and have not seen yours,
can you tell me how to get the procedure names and then close the vbe window
when done? I'm thinking as I write this my problem may be solved simply by
giving the focus back to the listbox I am updating. There is a procedure in
Access help "ALLProcs" that lists all of the procedures, but always leaves me
in the VB editor (very anoying!). Perhaps you could tell me how you deal with
this in your add-in? I would love to use your add in, however, since I am
going to bring a suite of add-ins to market very soon, I'm shy of seeing
other apps with similar functionality, for fear of jeoprodizing the
marketability of my app due to the copyrights of others... Please let me
know...

PS, How's Bend treating you? One of my favorite spots on the planet is
Mirror Pond Park.

Take care, and enjoy the vista for me till I can get back up there :-)

Signature

Everything in EXCESS!!! If you want to taste the flavor of LIFE, Take BIG
Bytes. Moderation is for monks…

> Mrcasey,
>
[quoted text clipped - 32 lines]
> > For the first question.....hummmm.....that sounds like an interesting
> > challenge. I think I'll add that to my "To-Do" list.

Reply to this Message