Access97 List of all forms

  • Thread starter Thread starter Jonathan Scott via AccessMonster.com
  • Start date Start date
J

Jonathan Scott via AccessMonster.com

I am trying to get a list of all forms, but am having no luck. As there is
Access97, there is no "AllForms" list I can reference. "Forms" just gives
me a list of open forms.

How can I get a list of the names (properties would be nice as well) of all
forms in Access97? Any help would be very much appreciated!

Jonathan Scott
 
Take a look at the Containers collection. Try this function ...

'----------------------------------
Public Function HowManyForms() As Integer
Dim db As Database
Dim doc As Document
Dim i As Integer

Set db = CurrentDb
For Each doc In db.Containers("Forms").Documents
i = i + 1
Debug.Print doc.Name

Next
Set db = Nothing
Debug.Print i

End Function
'-------------------------


- Jim
 
I am trying to get a list of all forms, but am having no luck. As there is
Access97, there is no "AllForms" list I can reference. "Forms" just gives
me a list of open forms.

How can I get a list of the names (properties would be nice as well) of all
forms in Access97? Any help would be very much appreciated!

Jonathan Scott
Click to expand...

Tools + Analyze + Documenter
 
Back
Top