Eliminating Old Queries

So I'm doing some cleanup, and I have a database with approximately 50
different queries. I'd like to delete the ones that aren't used
anymore. Is there a way for the database to search all forms and code
for instances of a particular query? Thanks!

Open any code module. From the menu select "Edit", "Find".
Check the "Current Project" for search area.
Enter your query name in the "Find What" box and if it is
mentioned in any code ( module or form) it will show you where.

Regards

Kevin

"DanCole42" <dancole42@gmail.comwrote in message
news:8cfca955-9463-4a1b-ae72-ebd925b2cb9c@d1g2000hsg.googlegroups.com...

Quote:

So I'm doing some cleanup, and I have a database with approximately 50
different queries. I'd like to delete the ones that aren't used
anymore. Is there a way for the database to search all forms and code
for instances of a particular query? Thanks!

I have a db (AK2) which you can import into your Db which shows where all
tables, queries, subforms and sub reports are used (As well as vice versa)
Doesn't check the code however.

Any use?

Phil
"DanCole42" <dancole42@gmail.comwrote in message
news:8cfca955-9463-4a1b-ae72-ebd925b2cb9c@d1g2000hsg.googlegroups.com...

Quote:

So I'm doing some cleanup, and I have a database with approximately 50
different queries. I'd like to delete the ones that aren't used
anymore. Is there a way for the database to search all forms and code
for instances of a particular query? Thanks!

Eliminating Old Queries

re: Eliminating Old Queries

re: Eliminating Old Queries

Similar Microsoft Access / VBA bytes

/bytes/development

/bytes/it

/bytes/about