Organizing VBA Project

Question

I am maintaining a large MS Access Project. Over time the number of modules and classes has grown, at this moment it contains 90 modules. More and more time do I spend searching for a specific class in the list. (I know about Shift+F2 :))

Is there any way to organize the list of modules in the VBA editor, i.e. some kind of Addin? My idea would be subfolders in the tree or a filter-as-you-type textbox.

Best regards, Torben

Community · Accepted Answer · 2020-06-20 09:12:55Z

2

First of all try: MZ-Tools. It has free version for MS Access. HomePage

It's a toolkit that help maintain access project in many aspects: create automatic documentation; create, modify and maintain procedures, functions and properties etc.

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Nov 30, 2009 at 11:12

juckobee

1,2291 gold badge12 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

guitarthrower · Accepted Answer · 2009-11-30 16:30:03Z

0

Develop a logical naming system. You can't get a tree per-se, but you can name things in a way that they are easier to find.

Module 1: A_systemtools
module 2: __systemtools_a
module 3: B_programitems
etc...

answered Nov 30, 2009 at 16:30

guitarthrower

5,9143 gold badges33 silver badges38 bronze badges

Collectives™ on Stack Overflow

Organizing VBA Project

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related