Listing Procedure Names

[Guest]

Is it possible to get a list of the Procedures/Functions held within a module
programmatically?

I am trying to do an audit on one of my modules but it contains loads of
procedures.....

Anyone help?

Cheers,
Steve.

 

[Dirk Goldgar]

Is it possible to get a list of the Procedures/Functions held within
a module programmatically?

I am trying to do an audit on one of my modules but it contains loads
of procedures.....

Anyone help?

Cheers,
Steve.

I went to Google Groups and searched for "list procedures in module
group:*.*access.*". This is one of the threads I found:


http://groups.google.com/group/comp...7706e?lnk=st&q=&rnum=2&hl=en#26fa69077887706e

 

[Guest]

Sorry, I cannot view that page from work!

Does it give an answer or would it be easier to go through manually?

Cheers,
Steve.

 

[Douglas J. Steele]

It gives an answer.

It's simply a webpage within Google. It doesn't make sense that you wouldn't
be able to view it from work, unless your IT group is even more paranoid
than ours at work. Is it possible that there's word-wrap involved, so you're
not navigating to the correct URL? Make sure you have everything on a single
line. (In actual fact, as long as you put everything before the ? mark into
the URL, you'll get the entire thread)

 

[Dirk Goldgar]

Sorry, I cannot view that page from work!

Does it give an answer or would it be easier to go through manually?

The answer involves making use of sample code that is in the help file.
Open your Access database and switch to the VB Editor window. Type
"ProcOfLine property" in the "Ask a Question" box on the toolbar (which
searches the help file), or open help and type "ProcOfLine" in the
index. The example code in the help entry for the ProcOfLine property
does what you're asking.

 

[Guest]

Dirk,

That answers my question, thanks!

Steve.

 

[Guest]

Our company is extremely paranoid about its staff having internet access. So
it is filtered up to the hilt!

We are lucky we can use google as a search engine it is that bad!

Everything that doesnt interest the managers seems to be blocked due to
being "personal pages"!!!!