Solved

Find (Ctrl-F) greyed out when not on module or form

Posted on 2010-11-26
4
366 Views
Last Modified: 2013-11-27
This may be the dumbest question I have asked since joining EE. But, can you even 'Search All' your code in the code window? Say I have 5 modules and 13 forms and want to find a specific piece of code. Without going to every form/module and doing a Find, how can you do that? Seems like I am missing something here. Is there no 'Search All' capabilites built in to Access 2007??
0
Comment
Question by:G Scott
  • 3
4 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Access MVP) earned 125 total points
ID: 34220500
Yes. Get this free tool:

http://mztools.com/v3/mztools3.aspx

quick install.  It has an AWESOME VBA search function ... searches ALL code.  I use it every day.  

mx
0
 
LVL 75
ID: 34220506
Oh, and it works in A2007 and A2010 also for sure.

The 'Find..." function is on the Right Click menu when you are in the vba editor - see images below.

If you select 'Project' in the Scope section, it will search the entire app's code, modules, form, class modules ... all of it.  In fact, you can even include code in an Add In mdb if you happen to have one (I usually do) by selecting Project Group.

Indispensable tool.

And while we are at it, get the other best ever Find and Replace tool:

http://www.rickworld.com/beta  (also works in all versions now - don't worry about word 'beta')

This will pay for itself in first use.  I also use this everyday.  Besides searching code, it also searches everything else too.

mx
Capture1.gif
Capture2.gif
0
 
LVL 1

Author Closing Comment

by:G Scott
ID: 34223178
LOL DatabaseMX, I already had it installed and never knew it was capapble of that. Thanks.
0
 
LVL 75
ID: 34224165
you are welcome.

MZTools has MANY cool features ... check time all out.

Same with F&R ...

mx
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

760 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now