Multi-Tab IDE for VBA7 ?

[Pietro_V]

Hello,
I'm new in this forum.
I'm migrating a set of older Access 97 Front-End applications to Access 2010.
I noted that the VBA7 IDE lacks of a multi-tab view that is very useful when working with many forms/modules.

Is there an add-on that you suggest to improve the IDE functionality in this way ?
Thank in advance



Pietro

[ranman256]

You could simulate the tabs with buttons side by side like a tab.
youd swap out the subForm with new query on each button.

[Pietro_V]

Hello Ranman

You could simulate the tabs with buttons side by side like a tab.
youd swap out the subForm with new query on each button.

I don't understand what you mean exactly.
I'm talking about the IDE, the code editor, where each module or form or report code is in an individual MDI window.
How can I create these buttons in the IDE ?

Pietro

[isladogs]

I'm talking about the IDE, the code editor, where each module or form or report code is in an individual MDI window.
How can I create these buttons in the IDE ?

Pietro

If I understand you correctly, what you are calling the IDE is actually the Visual Basic Editor (VBE).
You can show multiple code windows at once by choosing one of the options from the Window menu in the VBE.



I've used Cascade for the purposes of the above screenshot

[Pietro_V]

Hello Colin

If I understand you correctly, what you are calling the IDE is actually the Visual Basic Editor (VBE).
You can show multiple code windows at once by choosing one of the options from the Window menu in the VBE.



I've used Cascade for the purposes of the above screenshot

Thanks for the reply.
Yes I was referring to VBA editor.
I know how to handle multiple windows in an MDI environment, but when programming it is much easier to handle multiple modules maximized, and in that case a tabbed view would greatly help.
Please see the image below: it is taken from an old VB6 editor with a very simple add-in that just organize mutiple windows with tabs.



I'm just trying to achieve this in the VBA7 editor.
Frankly speaking I woukd have expected this to be already included as a regular feature... but it is not the case.

Any help is greatly appreciated.
Thanks

Pietro

[isladogs]

Hi
I can see the point of having this but AFAIK it cannot be done with the standard Access features.
I'm not aware of an free add-in that provides this functionality but you could try looking at MZ-Tools or some of the Total Access utilities from FMS
However, those are commercial projects.

Good luck in your endeavours. If you find anything, do report back so others can benefit.

[Pietro_V]

Thanks Colin,

Hi
I can see the point of having this but AFAIK it cannot be done with the standard Access features.
I'm not aware of an free add-in that provides this functionality but you could try looking at MZ-Tools or some of the Total Access utilities from FMS
However, those are commercial projects.

Good luck in your endeavours. If you find anything, do report back so others can benefit.

I have already tested MZ tool but haven't found any way to manage maximized windows with multi-tab. I also approached Rubberduck with no luck as well.
I will contact FMS to see if something is available, and will let you know

Thanks and Regards

[Micron]

I too would find it interesting if you find anything. The only thing I can think of that comes close is NotePad++ . While that will give you a multi-file vba code editor, it won't allow you to run the code to test. Closest you could come would be to have the code as files that you can reference or edit/save/copy/paste into VBE/save/compile/test