you're welcome, Steve. I posted the correct link after I realized the first one was wrong. This should give you exactly what you asked for :)
Thanks Bill and Crystal. I may be back with questions :-)
Steve
On 4/4/2019 1:20 AM, crystal 8 strive4peace2008@yahoo.com [MS_Access_Professionals] wrote:
https://www.msaccessgurus.com/VBA/SQL/sql_DocumentQueryTables.htm
On 4/4/2019 12:12 AM, crystal 8 strive4peace2008@yahoo.com [MS_Access_Professionals] wrote:
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
On 4/3/2019 3:10 PM, 'Bill Mosca' wrmosca@comcast.net [MS_Access_Professionals] wrote:
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 (7) |
Tidak ada komentar:
Posting Komentar