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 Form, Report, & Control Properties
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

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

Document Form, Report, & Control Properties

 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 Form, Report, & Control Properties
    Posted: 03 Jun 2012 at 9:15am

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,

Microsoft MVP
remote programming and training

Access Basics by Crystal
Free 100-page book that covers essentials in Access

   (: have an awesome day :)
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