Document SQL statements in Queries, Forms, and Reports.
Document SQL, RecordSource, and RowSource statements in Queries, Forms, and Reports to Microsoft Word. Test every statement. Mark Bad! statements so you can fix them, or verify they're okay. Count records when opened successfully. Show the SQL formatted with key words at the beginning of a line and line break + tab before commas. Write resports to Microsoft Word.
Free and not protected so you can learn — since this is just an ACCDB that has been renamed.
To avoid bloat in the current database, an external database is created to hold the tables that store information.
Document SQL is now on the Add-ins menu. When you run it, reports are written to Microsoft Word. The screen shows what is happening. When done, the folder with the Word report(s) is opened.
This add-in is a regular ACCDB file that has been renamed to have an ACCDA extension. It may be used freely, but you may not sell it in whole or in part. You may include it in applications you develop for others provided you pass on the download link and share the source code and designs with your modifications.
These are partial results of a Form SQL report in Microsoft Word. SQL is formatted to be easier to read. The number of records is counted if the statement runs successfully. Bad SQL is marked.
YouTube: How to Make and Install an Access Add-In (11:51)
Experts-Exchange (EE): How to Make and Install an Access Add-In (11:40)
YouTube: CalendarMaker and Document SQL at Access DevCon 2020 (15:03)
I recently changed a bunch of field names in the Analyzer, and am using this tool to help me fix the bad SQL statements, RecordSources, and RowSources.
Let's communicate, collaborate, and appreciate ... we all get better by sharing.
Email me anytime at info@msAccessGurus
Let's connect and team-develop while we build your application together. As needed, I'll pull in code and features from my vast libraries, cutting out lots of development time.
Email me at info@msAccessGurus
~ crystal