Re: [MS_AccessPros] SQL Statements documentation

 

Bill,

Create a little function in your standard modules:

Public Function GetSQL(strQueryName As String)

    GetSQL = CurrentDb.QueryDefs(strQueryName).SQL

End Function

Save the module with a name like "modDocumentation"

Then create a query with SQL of:

SELECT msysObjects.Name, GetSQL([Name]) AS [SQL]

FROM msysObjects

WHERE msysObjects.Name Not Like '~*' AND msysObjects.type=5;

Copy the results and paste into Word or Excel or change to a make table query.

Regards,

Duane

---

From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of Jim Wagner luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Thursday, March 2, 2017 7:11 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] SQL Statements documentation

 

Duane,

We have a situation that just came up. Where someone changed the format of a field in a table to number. I understand why. We download 26 tables each day and most of the fields are text. But some are naturally a number. If I join on these two fields I get a Type Mismatch error. So I wanted to find a quicker way to review the sql statements of the database than the documenter. I usually use the documenter and save it as a pdf to do a search on words. Plus, I though it would be nice to have all of the queries documented in a way to review them at once from several databases.

Jim Wagner

---

On ‎Thursday‎, ‎March‎ ‎02‎, ‎2017‎ ‎02‎:‎15‎:‎24‎ ‎AM, Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

 

Hi Jim,

MS doesn't document this (and lots of other internals). Why do you want this? If you are documenting your application, you can use a little DAO code to retrieve the SQL property of the querydefs.

Regards,

Duane Hookom

---

From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Wednesday, March 1, 2017 4:46 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] SQL Statements documentation

 

Hello all,

I was looking for the SQL statements in the System tables and I could not find them. But they are an option to show in the documenter. Where are the statements stored?

Thank You

Jim Wagner

__._,_.___

---

Posted by: Duane Hookom <duanehookom@hotmail.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (5)

---

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

.

__,_._,___