473,320 Members | 1,896 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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!
Jul 8 '08 #1
2 1044
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" <da*******@gmail.comwrote in message
news:8c**********************************@d1g2000h sg.googlegroups.com...
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!

Jul 8 '08 #2
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" <da*******@gmail.comwrote in message
news:8c**********************************@d1g2000h sg.googlegroups.com...
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!

Jul 8 '08 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
by: Nick Coghlan | last post by:
Time for another random syntax idea. . . So, I was tinkering in the interactive interpreter, and came up with the following one-size-fits-most default argument hack: Py> x = 1 Py> def...
5
by: gordy | last post by:
edit: this came out longer than I thought, any comments about anything here is greatly appreciated. thank you for reading My system stores millions of records, each with fields like firstname,...
27
by: Mr. Ed | last post by:
This should be easy, but I can't immediately see what the answer is... I have some code which needs to be re-entrant. It also needs to create a unique identifier. The obvious way to create a...
7
by: Eric Slan | last post by:
Hello All: I'm having a problem that's been baffling me for a few days and I seek counsel here. I have an Access 2000 DB from which I want to run several reports. These reports are...
5
by: MX1 | last post by:
Hi, I have a report with Name1 and Name2 in the address section . Sometimes, Name2 is not populated with data via the query that feeds the report. Unfortunately, the blank line stays in the...
1
by: John Baker | last post by:
Hi: I have W98 and Access 2000, and am running a fairly complex application with all sorts of delete and append queries. These queries run in background on my system, and make no fuss when they...
6
by: Marlene | last post by:
Hi All I have the following scenario, where I have found all the duplicates in a table, based on an order number and a part number (item).I might have something like this: Order PODate Rec...
10
by: Pramodhegde | last post by:
Hi, I am new to VB application development with Access. I have a task of copying queries from one DB to another, without duplicationg the ones that are already existing in the destination DB (the...
5
jamesd0142
by: jamesd0142 | last post by:
My manager and I where looking at some complex code to eliminate duplicate records in a database table. then it hit me how its done easily... so i thought i'd share it... In English:...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.