Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Find queries, macros, etc. that are not called

Posted on 2011-09-12
5
Medium Priority
?
244 Views
Last Modified: 2012-06-27
I inherited 3 applications from former staff that have lots of pieces to them that I think may have been rewritten (and replaced) though not removed from the applications. Is there a reliable utility available that can isolate uncalled Access components?
0
Comment
Question by:bobhiii
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 36522661
you can try "find and replace"

http://www.rickworld.com/download.html

0
 
LVL 77

Accepted Solution

by:
peter57r earned 501 total points
ID: 36522672
0
 
LVL 17

Assisted Solution

by:andrewssd3
andrewssd3 earned 498 total points
ID: 36522731
I like http://www.mztools.com/v3/download.aspx.  It's free and there are a lot of useful tools for VBA here - the Review Sourcecode utility reports on unused procedures and variables.
0
 
LVL 31

Assisted Solution

by:Helen Feddema
Helen Feddema earned 501 total points
ID: 36523189
If you can throw money at the problem, get Total Access Analyzer from FMS.  

http://www.fmsinc.com
0
 

Author Closing Comment

by:bobhiii
ID: 36545910
Was hoping for a response that Googling wouldn't provide, more like a hidden gem.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

721 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question