Re: [MS_AccessPros] Documenting Queries and Reports

 

(thanks, Bill)

hi Joanne,

here is a way to document SQL statements.  It creates a Word document:

Document Query SQL, Form and Report RecordSource
http://www.rogersaccesslibrary.com/forum/document-query-sql-form-and-report-recordsources_topic606.html

The Analyzer on CodePlex (until it gets moved since CodePlex is shutting down) documents a ton of stuff and is here:

http://analyzer.codeplex.com

Both of these tools are free and open-source.

respectfully,
crystal

http://www.MsAccessGurus.com
connect to me, let's build it together
 
~ have an awesome day ~

On 4/15/2017 1:51 PM, 'Bill Mosca' wrmosca@comcast.net [MS_Access_Professionals] wrote:

Joanne

Access has a built-in documenter under the Database Tools tab. And there are a few documenters in our Files>Crystal folder. Crystal has done some great work in this area. <clip>

 

Regards,
Bill Mosca,
Founder, MS_Access_Professionals

MS Access MVP 2006-2016
That'll do IT http://thatlldoit.com

My Nothing-to-do-with-Access blog

http://wrmosca.wordpress.com

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Saturday, April 15, 2017 10:04 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Documenting Queries and Reports

 

 

(Again with apologies as a newbie) I have searched the conversations and not found a discussion of recommended ways to document the queries and reports contained within a database. Also  I find it frustrating that I cannot document within the SQL code. 

Can someone share with me how they create and organize documentation?

Joanne

__._,_.___

---

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 (3)

---

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

.

__,_._,___