Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Find queries, macros, etc. that are not called

Posted on 2011-09-12
5
Medium Priority
?
246 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
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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
New style of hardware planning for Microsoft Exchange server.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

879 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