Roger's Access Library Homepage
Forum Home Forum Home > Other Download Libraries > MS Access MVP Libraries > Long, Crystal
  New Posts New Posts RSS Feed - Document Query SQL, Form and Report RecordSources
  FAQ FAQ  Forum Search   Events   Register Register  Login Login


Please consider donating $1 per sample downloaded, (find out why here)

Document Query SQL, Form and Report RecordSources

 Post Reply Post Reply
Author
Message
Crystal Long View Drop Down
Microsoft MVP
Microsoft MVP


Joined: 21 May 2012
Location: Colorado
Status: Offline
Points: 31
Post Options Post Options   Thanks (0) Thanks(0)   Quote Crystal Long Quote  Post ReplyReply Direct Link To This Post Topic: Document Query SQL, Form and Report RecordSources
    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

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
Remote Training & Programming - Access, Excel, word, PowerPoint, Camtasia, and more.
http://www.AccessMVP.com/strive4peace
Back to Top
Sponsored Links


Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down