Help needed with custom Add-in

[Kowalski]

Hi
I'm trying to create a custom Add-In for Access 2010.
I've created the add-in, and gave it a new ribbon with some buttons that will run my custom functions. I've created a accde file from that.

Next, I've opened a new accdb where the Add-in should be added, and added it with the Add-In Manager.
When I try to run it I get a "The wizard you've requested is not installed or is in a bad state" message.
Most google results for that seems to address normal access wizards and not add-ins.

Any help will be appreciated.

 

[Guus2005]

V-Tools is an addin and the code is also available. You can use it as a base for your own Addins. JFGI

HTH

 

[Kowalski]

Hi
I've downloaded the add-in and it works, but I can't see how I can use that as a base for my own add-ins. Don't see how I can add items to the Add-in menu that will call my functions, or change V-Tools as it is locked.
Thanks for the reply.

 

[Guus2005]

When you check-out this link you'll find his sourcecode.

Enjoy!

 

[Kowalski]

How to add add-ins in Access 2010:
Open registry
Go to: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\14.0\Access\Menu Add-Ins
Add the entry as a new Key that should appear in the menu
Add 2 string values to the key:
1. Library: Value = Path to accdb or accde file where item is stored
2. Expression: Value = Function name to call item e.g. =MyFunction()

And no, Microsoft could not have made it any easier. What can be easier than that?

 

[Guus2005]

Did you create an Add-In you want to share?

Sample Databases

 

[Kowalski]

Not really . It's a tool from a different company and I do not have authority to distribute it.