• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 389
  • Last Modified:

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??
0
G Scott
Asked:
G Scott
  • 3
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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 MVP, Access and Data Platform)Commented:
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 MVP, Access and Data Platform)Commented:
you are welcome.

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

Same with F&R ...

mx
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.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now