thanks, Bill
Steve, I have posted lots of tools to document databases -- but to get the results to specifically list the names of underlying source tables and queries, here is some SQL you can make a query with:
SQL > Document > Query underlying tables and queries
http://msaccessgurus.com/VBA/Code/sql_DocumentQueryTables.htm
have an awesome day,
crystal
free code you can use in your projects
https://msaccessgurus.com/code.htm
Steve – Check our Files section. I think you will find a documenter in Crystal's folder.
Regards,
Bill Mosca
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Monday, April 01, 2019 5:22 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Access listing tool
Is there a way within Access 2016 to list the queries and each query's
underlying tables/queries? Or perhaps an external tool or add-on?
Thanks, Steve
Posted by: crystal 8 <strive4peace2008@yahoo.com>
Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (4) |
Tidak ada komentar:
Posting Komentar