Listing forms and properties

[PaulSpell]

Does anyone happen to have some code that loops through all forms (open or not) and lists the form name, desription property and the code behind the form? I want this to produce some documentation.

I've had a very very long week and my brain is completely addled, I've been trying to get this to work for hours but am just going around in circles. I can list the forms ok, but can't bring in the properties.

Can anyone help?

 

[Mile-O]

Does anyone happen to have some code that loops through all forms (open or not) and lists the form name, desription property and the code behind the form? I want this to produce some documentation.

You can use the Database Documenter in the Tools menu to list forms and their descriptions.

As for the code, what do you mean by listing: the whole lot or the names of subs and functions?

 

[PaulSpell]

I don't like the format of the documenter, I'd rather produce my own report.

As for the code, I want it all printed out.

What I am trying to get to is something along these lines:


Formname: frmA_Name_Here
Description: Some descriptive text here

Code: All of the code here.


I have around 100 forms and want to setup a function that lets me output this to Word or something so that I can include it in my documentation.

 

[PaulSpell]

No-one?

 

[namliam]

Currentdb.Containers("Forms").Documents(0).name

Will show you the name off the FIRST form in your DB. I am sure if you experiment around with that and a For each in .... next loop you can find the stuff you are loooking for....

Regards

 

[PaulSpell]

I can get the name of the forms, no problem. But am having probs with printing the code.

 

[Mile-O]

Maybe the code in this thread will help you print out the code.

 

[PaulSpell]

Mile-O-Phile, thanks for the code. But I already have some code that prints modules by looping through the modules container.

The problem I'm having is looping through the forms container printing what I want and then passing the appropriate form name to print the code!

 

[PaulSpell]

Still struggling with this, anyone got some ideas?