Question Obsolete forms, query's, etc

[Birdman895]

Hi,
This may be a dumb question but... is there anyway to weed out unused forms, query's. I have searched code for references to these items, and finding none I deleted them. Only to find out that I was still referencing that object in an obscure area that I worked on a couple months ago.
Is there a way to find references in queries, rowsources, filters etc.

thanks in advance

 

[Isskint]

You could look at Tools>>Analyze>>Documentor

Also you can look at dependencies. Right click a table/form/query and select Object Dependencies. These 2 methods will give you some insight into what objects are associated to each other.

As for identifying unused forms, you could attach a little VBA to a forms on open event to record date/time used (record this to a table or external text file). After a while you could check this list to see if there are any forms notlisted.

 

[Birdman895]

Thanks for the help.
I think the Object Dependencies are just what I needed to clean things up.
Thanks again