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 Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Looking for an add in that can catalogue queries

Status
Not open for further replies.

HarryStamper

Programmer
Jul 24, 2006
15
US
Is there an add in for access that will group/and document queries. I suppose this can be done in several ways...i am interested in ways you all document your queries....

thanks
 
i do have something like that but all the queries are in text files. i have a vb script that reads each first line of all the text files in a query folder, and looks for a particular string that i input in the vbs. let's say that i am looking for a query that has "inner join" or accesses "customer data and orders". the msgbox displays the first line of the query (a comment). if i choose yes, it will write it that text file to the notepad on the desktop. if i choose no, then it will go to the next one that has that string. i copy the query and paste it in access query and run it. or i can run it directly from vbs.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top