Executing Add-In from a custom form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

geskerrett@hotmail.com - 28 Sep 2006 19:28 GMT

I am sure I am not the only one to ask this, so hope someone can point
me in the right directions.

I have a working add-in developed with Access 2003 and VBA. I can
connected in to a database va Add-In Manager and everything works
great.

I would like to link the startup function of the AddIn to a custom form
so the user doesn't have to go thru the menu prompts each time to get
to the addin manager.

Can this be accomplshed ??
If so how ?? I have been searching for too long !

Reply to this Message

Granny Spitz - 28 Sep 2006 19:55 GMT

>I am sure I am not the only one to ask this

You're right. A similar question was asked yesterday.

http://www.accessmonster.com/Uwe/Forum.aspx/access/75624/How-to-Customize-a-Tool
bar-to-launch-an-Addin

You can use the line of code in your form's Open event or in a button's click
event.

Application.CommandBars("Tools").Controls("Add-Ins").Controls("NameOfAdd-
In").accDoDefaultAction

Reply to this Message