[AccessD] combo box 101

On 9 Aug 2011 at 21:04, William Benson (VBACreations. wrote:

> I think those who are comfortable with a lot of queries in their
> database -- which there is no easy way to tell where that query is
> being used, either in rowsources or in dependent queries ... probably
> work in very stable object environments.
> 


That's my main concern too.

If you only use queries in  VBA, it is easy to search and tabulate all occurences of a query 
name so that you can easily determine all the places it is used.  That means that you can 
ensure that it is safe to modify/delete queries.

If however you use them as the source of various controls/forms/reports it is MUCH harder to 
determine whether it is safe to modify/delete a query.  

1. I've deleted this combobox on this form. Can I delete the query that I used to populate it or 
is it used by another combobox somewhere on another form/report? 

2.  Users now want this combobox on this form sorted by firstname instead of lastname.  
Can I safely change the sort order of the query - Is the same query used in another 
combobox on another form?
Do I have to create a new one query for this combobox or is there another query somewhere 
already that does this which I can use instead?
If I use a different query, can I safely delete the old one or is it still in use elsewhere?

3.   There have been a number of changes made to various components of the application.  
Which of these queries are still in use somewhere and which should be deleted?


-- 
Stuart