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
Crystal Long View Drop Down
Microsoft MVP
Microsoft MVP

Joined: 21 May 2012
Location: Colorado
Status: Offline
Points: 35
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:


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

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:

    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,
Microsoft MVP
Remote Training & Programming
Let's Connect and Build Together
~have an awesome day ~
Back to Top
Sponsored Links

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.03
Copyright ©2001-2019 Web Wiz Ltd.