finding orphaned forms 1

[galorin]

I have a project with about 50 forms in it. Some of these forms are obsolete, and no longer referenced by any other form, or even opened directly. Is there an easy way to find out what forms are not linked to others, or not opened by docmd.openform?

 

[JBinQLD]

I didn't think to search on here for an answer, i was just gonna write logic to do it tomorrow and leave it running over the weekend (I also need to check for crapped out queries and reports) so I'll follow this thread with interest and if no response soon I'll just bite the bullet and post my code.

I'm planning on extracting all logic into a table first, then all rowsources, etc, then go through the database collection and check for references.

Many of my objects I know ARE in use so I'll exclude them from the loops by tagging them with a comment and checking. Would be nice if someone has already done the chunk of this for me but hey ho, not difficult stuff, just time consuming!

JB

 

[PHV]

Have a look here:

http://mdbdoc.sourceforge.net/

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[JBinQLD]

I've looked there in the past, and it's on my favourites, was gonna be my first port of call in the morning for a revisit, but have a star anyway so people can see you've given some good advise as always! Cheers, JB