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

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??
LVL 1
G ScottAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
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
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
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
 
G ScottAuthor Commented:
LOL DatabaseMX, I already had it installed and never knew it was capapble of that. Thanks.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
you are welcome.

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

Same with F&R ...

mx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.