Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to list SQL text of queries?
Never mind - I figured it out. Here's my code: Dim obj As AccessObject, dbs As Object Open "Capitation_Queries.txt" For Output As #1 Set dbs = Application.CurrentData For Each obj In dbs.AllQueries Print #1, "Query: " & obj.Name &...- aludden
- Post #2
- Forum: Microsoft: Access Modules (VBA Coding)
-
How to list SQL text of queries?
Hello! I want to list the sql of all my queries in a database, like the documenter does, except I don't like the way documenter does it. Is there an object property I can list/iterate through? Thanks! alex- aludden
- Thread
- Replies: 1
- Forum: Microsoft: Access Modules (VBA Coding)
