Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MS Access Module Key-Word Search (for External Apps)

Status
Not open for further replies.

Darrylles

Programmer
Feb 7, 2002
1,758
GB
Hi,

After realizing that we can't always imagine all eventualities (and certainly cannot predict management direction) I've produced an application that enables you to:
[ul]
[li]Maintain a list of all applications that you wish to be searched for 'key' VBA words / terms.[/li]
[li]Search for a key word / term within all of those external application:[/li]
[ul]
[li] Modules[/li]
[li] Form modules[/li]
[li] Report modules[/li]
[/ul]
[li] All resultant 'object containers' (regardless of naming convention) will be prefixed with ',Module_, Form_, Report_' to indicate their type.[/li]
[li] On double-clicking the object container name - that object will be opened in design mode.[/li]
[li] You'll need to Edit - Find the term in that objects' module.[/li]
[li] I will be (at some point) adding functionality to automatically 'search and replace'[/li]
[/ul]
The 'app' is really one, single form, stored as text in SNIPT, which when first run - creates 2 tables in order to function.

If you're interested, then you can upload it here and use LoadFromText to import this single form into a new MS Access app.
Full import / install instructions are on SNIPT.


It's not 'bullet-proof' designed, although common error trapping has been used.
Let me know your thoughts; it's certainly pulled me out of the chit when the pressure has been on, to remedy a commonly used piece of code that needed to be amended in lot's of places.

Darrylle ;-)

Never argue with an idiot, he'll bring you down to his level - then beat you with experience.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top