Re: [MS_AccessPros] Access listing tool

 

great! thanks for letting us know, Steve -- and thanks for sharing what was wrong

have an awesome day,
crystal

free code you can use in your projects
https://msaccessgurus.com/code.htm

On 4/5/2019 1:16 PM, Steve thaw5  [MS_Access_Professionals] wrote:

Crystal,

You are right. I did copy more than just the SQL statement. It's working now.

Thank you!

Steve

On 4/5/2019 1:49 PM, crystal 8 strive4peace [MS_Access_Professionals] wrote:

 

Hi Steve,

I updated the web page with another example. Perhaps you copied more than just the SQL statement? Extra spaces and line breaks don't matter where there can be space ... but there may not be space before or after it.

have an awesome day,
crystal

On 4/5/2019 10:39 AM, Steve thaw5 [MS_Access_Professionals] wrote:

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

On 4/4/2019 1:20 AM, crystal 8 strive4peace [MS_Access_Professionals] wrote:

 

https://www.msaccessgurus.com/VBA/SQL/sql_DocumentQueryTables.htm

On 4/4/2019 12:12 AM, crystal 8 strive4peace [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 (11)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

SPONSORED LINKS

.

__,_._,___