idtextensibility2 onconnection with mda (without dll)?

M

Mark Schneider

We are currently developing a simple Access Add-In using VBA. It features
all we need but cannot automatically insert CommandButtons to Commandbars.
It's an addin for the VBE Editor in Access
which allows us to format Code, insert Templates, line numbering and so on.

But unfortunately we have to start the Plugin in the main Access Window
Pulldown Menu "Extras > Add-Ins" each time we start Access to let it build
the command bar buttons.

Is there any way to get an event for a pure VBA .mda-Add-In when it is
installed?

Is there any way to get the idtextensibility2 event "onconnection" working
in an .mda without converting it to VB/C/.NET-Addin or an .dll?

Is there a way to force Access to do a certain action each time it starts
other than the autoexec-macro of the Applications?
We create the command bar using:
application.vbe.commandbars.add(Name:="addinCommandbar", Position:msoBarTop,
temporary:=false)

Is it possible to create persistent commandbars in VBE via VBA from the
Add-In that stay even if you close and restart Access?

We don't have VSTO (Visual Studio Tools for Office) or Office 2000/XP
Developer.
The only thing we have for Development is Office 2003 Professional.

Any ideas?
TIA
Mark
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top