Brilliant!
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, March 02, 2017 6:48 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: 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
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (6) |
Tidak ada komentar:
Posting Komentar