snippets / Loop durch alle Access Datenbank Container und Objekte

Language: C++ - First posted by qrist0ph on 2008-05-9 10:07 (1 month, 3 weeks)
Link to the snippet: http://www.friendsnippets.org/snippet/298/

.

 1 Sub foo()
2 With CurrentDb
3 ' Durchlaufen der Containers-Auflistung.
4 For Each ctrLoop In .Containers
5 Debug.Print "Eigenschaften von" & ctrLoop.Name & " Container"
6 ' Durchlaufen der Properties-Auflistung jedes
7 ' Container-Objekts.
8 For Each prpLoop In ctrLoop.Properties
9 Debug.Print " " & prpLoop.Name & " = "; prpLoop
10 Next prpLoop
11
12 For Each it In ctrLoop.Documents
13 Debug.Print it.Name
14 Next
15 Next ctrLoop
16 End With
17 End Sub
In order to post a comment, you should have a friendsnippet account. Please sign-in.

0 comments

May '08

Common Tags



snippet History

May '08