Document Form, Report, & Control Properties |
Post Reply |
Author | |
Crystal Long
Microsoft MVP Joined: 21 May 2012 Location: Colorado Status: Offline Points: 35 |
Post Options
Thanks(0)
Posted: 03 Jun 2012 at 9:15am |
uploads/84/Crystal_Doc_Objex_090702__MDB_TXT.zip
Document Form, Report and Control Properties How many times have you tried to find an error in a property setting? A function that is wrong in an event property? A setting in the wrong place? Do you want an easy way to document the RowSources of all combos and listboxes? How about a list of all control names and control sources? All this is possible with the module in the attached database, bas_Crystal_Doc_Objex_090702 To find calculated fields, filter Doc_cPropz for =* To find controls with code, filter for [Event Procedure] or =* This is very powerful -- but you will have to write your own queries and reports on the data. Import the 4 tables +1 module into the db to document. 'Doc_Objex - names of Forms and Reports and the main properties 'Doc_Controlz - Control Name/Type. 'Doc_cPropz - control properties 'Doc_ObjErrors - errors 'bas_Crystal_Doc_Objex_090702 - module Read module comments and Field Descriptions. to clear data: 1. open Doc_Objex 2. press Ctrl-A to select all the records 3. press the DELETE key to delete the selected records The relationships have Cascade Delete set so all related records will automatically be deleted. This tool has been designed to hold just one analysis as there is no field to group the objects that were analyzed. The best way to distinguish different time of analysis is the dtmAdd field, which is the date and time that a record was created. Feedback is appreciated, thank you Warm Regards, Crystal Microsoft MVP remote programming and training Access Basics by Crystal http://www.AccessMVP.com/strive4peace Free 100-page book that covers essentials in Access http://www.YouTube.com/LearnAccessByCrystal * (: have an awesome day :) * |
|
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 |