Document Query SQL, Form and Report RecordSources |
Post Reply |
Author | |
Crystal Long
Microsoft MVP Joined: 21 May 2012 Location: Colorado Status: Offline Points: 35 |
Post Options
Thanks(0)
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 Microsoft MVP Remote Training & Programming Let's Connect and Build Together http://www.AccessMVP.com/strive4peace http://YouTube.com/LearnAccessByCrystal ~have an awesome day ~ |
|
Sponsored Links | Want a good read? Try The Summer of His Life (available on Amazon!) |
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |