Access Documentor for Forms

StacyStacy

A "Californian" at heart!
Local time
Today, 04:50
Joined
Jan 29, 2003
Messages
159
How do add a specific form in the documentor under "Analysis" in the pulldown menu? I see all of my tables and queries, but not my forms.

Thanks,
 
This will show all your tables and quries

Put this in your combo box's row source (row source type: table/query selected)

SELECT MsysObjects.Name AS ObjectName, IIf([type]=1 Or [type]=6,"Table","Query") AS ObjectType FROM MsysObjects WHERE (((Left$([Name],1))<>"~") AND ((Left$([Name],4))<>"Msys") AND ((MsysObjects.Type)=1 Or (MsysObjects.Type)=5 Or (MsysObjects.Type)=6) AND ((MsysObjects.Flags)=2097152 Or (MsysObjects.Flags)=128 Or (MsysObjects.Flags)=0 Or (MsysObjects.Flags)=16)) ORDER BY MsysObjects.Name;

Bye
 
I figured it out. All of my forms are hidden. I unhid the form I needed documented.

In the pulldown menu, go to:
"Tools"
"Analyze"
"Documenter"
Choose Forms
 

Users who are viewing this thread

Back
Top Bottom