Crystal,
I am unable to save the pasted-in query. When I attempt to save, Access highlights the top line and the first character of the second line and gives me this error in a popup: Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'.
I don't think it matters, but the line indentations do not survive the copy/paste operation.
The instructions are pretty simple but somehow I've managed to botch it. Any ideas?
Steve
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: Steve thaw5 <thaw5@suddenlink.net>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (8) |
Tidak ada komentar:
Posting Komentar