By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,335 Members | 2,718 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,335 IT Pros & Developers. It's quick & easy.

Get names and types of modules/forms VB sub, functions and variables

P: n/a
Hi!

Is it possibile to get names and types of functions, subs and variables
included in modules and forms VB code?
The reason - I must to create documentation of application.
I would to automate this process.
So far I've created proedure whitch return the list of all
objects od my DB like forms, modules, reports, tables, views and sps.
And procedure based on regular expr. whitch give me list of all
variables, subs and functions includet in some text.
The problem is that I must to paste this text into editbox, because
I don't have any idea how to get it directly from form's or module's
code ;)

Can anyone help me or say (if) it's IMPOSSIBLE :]

Regards, Leon!
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Not 100% sure what your syaing, but if you're talking about Access module
objects, then you can access each one by going throught the Modules
collection of the Database object. There are a number of methods(functions)
you can use here or with the individual Module object, that provide a number
of different pcs of information.

Mike Storr
www.veraccess.com

"Leon" <et**@op.pl> wrote in message news:bu**********@news.onet.pl...
Hi!

Is it possibile to get names and types of functions, subs and variables
included in modules and forms VB code?
The reason - I must to create documentation of application.
I would to automate this process.
So far I've created proedure whitch return the list of all
objects od my DB like forms, modules, reports, tables, views and sps.
And procedure based on regular expr. whitch give me list of all
variables, subs and functions includet in some text.
The problem is that I must to paste this text into editbox, because
I don't have any idea how to get it directly from form's or module's
code ;)

Can anyone help me or say (if) it's IMPOSSIBLE :]

Regards, Leon!

Nov 12 '05 #2

P: n/a
Have a look and see if the "Generate XML Documentation" in MZ Tools
(www.mztools.com) fits your requirements.

Terry
"Leon" <et**@op.pl> wrote in message news:bu**********@news.onet.pl...
Hi!

Is it possibile to get names and types of functions, subs and variables
included in modules and forms VB code?
The reason - I must to create documentation of application.
I would to automate this process.
So far I've created proedure whitch return the list of all
objects od my DB like forms, modules, reports, tables, views and sps.
And procedure based on regular expr. whitch give me list of all
variables, subs and functions includet in some text.
The problem is that I must to paste this text into editbox, because
I don't have any idea how to get it directly from form's or module's
code ;)

Can anyone help me or say (if) it's IMPOSSIBLE :]

Regards, Leon!

Nov 12 '05 #3

P: n/a
Any reason why you don't use the built in database documenter?

You should/will play with some of the options, as it will kill a lot tress
in the process. However, you can get some nice listings of all forms, code
modules etc.

The documentor will even list out all your tables, fields and indexes. And,
if you play with the option, that table list is columnar.

Try the options on a small test database until you get some outputs. Then,
fill your printer up with paper, and let it run!
--
Albert D. Kallal (MVP)
Edmonton, Alberta Canada
No************@msn.com
http://www.attcanada.net/~kallal.msn
Nov 12 '05 #4

P: n/a

Użytkownik "Albert D. Kallal" <pl********************@msn.com> napisał w
wiadomo¶ci news:_U1Nb.82692$JQ1.4276@pd7tw1no...
Any reason why you don't use the built in database documenter?

You should/will play with some of the options, as it will kill a lot tress
in the process. However, you can get some nice listings of all forms, code
modules etc.
I know this solution ;)
Try the options on a small test database until you get some outputs. Then,
fill your printer up with paper, and let it run!


I want to obtain rather editable document :|

But thanx for yours sugestions ;)

Leon! :)
Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.