Can you see what modules use a field in a table
- Thread starter AccNovice
- Start date
not sure
i dnt no if you can do it for a field but i no you can do it for a whole table by right clicking on the table and select.
"Object Dependicies" last on list and then you can choose items that relie on me in the side box and it will tell u every thing that needs that able to work from querys to forms handy thing to use if yr thinking of change or deleting a table and are not sure what it will affect
hope this helps
i dnt no if you can do it for a field but i no you can do it for a whole table by right clicking on the table and select.
"Object Dependicies" last on list and then you can choose items that relie on me in the side box and it will tell u every thing that needs that able to work from querys to forms handy thing to use if yr thinking of change or deleting a table and are not sure what it will affect
hope this helps
georgedwilkinson
AWF VIP
- Local time
- Today, 14:02
- Joined
- Mar 4, 2008
- Messages
- 3,819
I used VTools for this today. Somebody posted a link to VTools on this forum which is how I found it.
Exactly what information does this tool give you George?
Just knowing what modules specifically reference a column in a table is such a small
part of the whole picture.
A table's column's can be referenced in modules, forms, macros and queries. That's a
lot of places to track. A login ID, can make it from the table, to a form control,
then either assigned to a global or placed on the "hidden" main form. How can all
of that be tracked?
A form having a ControlSource object can call a Public function passing the form as
a parameter. That's tough to track.
That doesn't even take into account for table-driven forms. There are a million ways
to confuse the tracking.
Is this kind of stuff for metrics?
Just curious,
Wayne
Just knowing what modules specifically reference a column in a table is such a small
part of the whole picture.
A table's column's can be referenced in modules, forms, macros and queries. That's a
lot of places to track. A login ID, can make it from the table, to a form control,
then either assigned to a global or placed on the "hidden" main form. How can all
of that be tracked?
A form having a ControlSource object can call a Public function passing the form as
a parameter. That's tough to track.
That doesn't even take into account for table-driven forms. There are a million ways
to confuse the tracking.
Is this kind of stuff for metrics?
Just curious,
Wayne
Pat,
Definitely a good point, but it's still people writing the code, and they're
not always too keen on following the rules.
Also, what about linked tables, etc. That would seem to be a very
tough part of the analysis.
I just see too many loopholes that render the information gathered as
only of statistical value.
Wayne
Definitely a good point, but it's still people writing the code, and they're
not always too keen on following the rules.
Also, what about linked tables, etc. That would seem to be a very
tough part of the analysis.
I just see too many loopholes that render the information gathered as
only of statistical value.
Wayne
georgedwilkinson
AWF VIP
- Local time
- Today, 14:02
- Joined
- Mar 4, 2008
- Messages
- 3,819
Having only used VTools once (yesterday), I was surprised at how "deep" it went. There are options to select which objects you want to check references in. It can check all the properties of all the objects (including combo-box source, modules, and query SQL) in the database. I was actually trying to write my own tool for doing this and decided to try VTools out. I'll never bother with writing my own again.
Now I remember where I got the link for VTools, on Bob Larson's site: http://www.btabdevelopment.com/main/FreeAccessToolsbyOthers/tabid/100/Default.aspx
Now I remember where I got the link for VTools, on Bob Larson's site: http://www.btabdevelopment.com/main/FreeAccessToolsbyOthers/tabid/100/Default.aspx
boblarson
Smeghead
- Local time
- Today, 12:02
- Joined
- Jan 12, 2001
- Messages
- 32,040
I use the Total Deep Search tool that is in the V-Tools add-in quite a bit. It has been very, very useful and you can't beat the price (free). Skrol29 has been very good with providing that tool (including the source code) and he had recently updated them for use with Access 2007 as well. I also like the V-Tools personal objects repository for being to quickly add items that I've preformatted into a database.
