Print Page | Close Window

Document Query SQL, Form and Report RecordSources

Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Long, Crystal
Forum Description: Access Basics is designed for those of you with a thirst to understand the fundamentals of Access with programming in mind ... whether you realize it or not.
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=606
Printed Date: 11 Dec 2017 at 6:36am


Topic: Document Query SQL, Form and Report RecordSources
Posted By: Crystal Long
Subject: Document Query SQL, Form and Report RecordSources
Date Posted: 13 Nov 2012 at 1:03am
Document Query SQL, Form and Report RecordSources, and create query to show main objects

Here is code to DOCUMENT the SQL stored for each QUERY. You can also document the source for FORMS and REPORTS. You can also create a query that lists the main object names and types in your database.

    click in first procedure, Run_Word_CreateDocumention_SQL, and press F5 to Run!
    A Word document showing the SQL for all your queries will be created.

To use this module to document RecordSource for forms or reports, run one of the following procedures:

    Run_Word_CreateDocumention_Forms
    Run_Word_CreateDocumention_Reports

To create a query from the MSysObjects table with a list of all the main object names and types in your database, run Run_Create_qObjex_byCrystal_Query

BAS module
uploads/84/bas_crystal_Document_QrySQL_FrmRptRecordSource_2Wrd_Create_qObjx.zip - uploads/84/bas_crystal_Document_QrySQL_FrmRptRecordSource_2Wrd_Create_qObjx.zip

to import a module into your database, UNZIP it to pull out the BAS file

then open the database you want to document, press Alt-F11 to go to a Visual Basic window.  From the menu, choose: File, Import

Navigate to:
bas_crystal_Document_QrySQL_FrmRptRecordSource_2Wrd_Create_qObjx.bas

    NEEDS reference to
    Microsoft DAO Object Library or Microsoft Office ##.0 Access Database Engine Object Library
    (from the menu: Tools, References...)

    Debug, Compile and then Save

then run each of the four procedures at the top that are named Runblahblah




-------------
Warm Regards,
Crystal
Microsoft MVP
Remote Training & Programming
Let's Connect and Build Together

http://www.AccessMVP.com/strive4peace
http://YouTube.com/LearnAccessByCrystal
~have an awesome day ~



Print Page | Close Window