Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error creating AddIn for Access 2010

Status
Not open for further replies.

FancyPrairie

Programmer
Oct 16, 2001
2,917
US
I have created an Access 2010 db that I want to use as an AddIn (wizard). I have created the USysRegInfo table and populated it. And it seems to install ok (I can see it in the registry). USysRegInfo simply adds a menu item that, when selected, runs some code that opens a form. However, when it is launched I receive the error "The wizard you've requested is not installed or is in a bad state." I tried setting the wizard up to run a macro to open the form rather than running some code to do it. This time when I launch it I get the message "Can't find the macro MacroName". If I create a macro in my database with the same name as the one in my wizard database, the wizard will launch that one with no errors.

So, why is the wizard attempting to launch the macro in the current database rather than the macro that resides in the wizard database?

Here's the definition of USysRegInfo (3 records):

Record 1:

SubKey: HKEY_CURRENT_ACCESS_PROFILE\Menu Add-Ins\My Wizard
Type: 0
ValName:
Value:

Record 2

SubKey: HKEY_CURRENT_ACCESS_PROFILE\Menu Add-Ins\My Wizard
Type: 1
ValName: Expression
Value: MacroName

Record 3

SubKey: HKEY_CURRENT_ACCESS_PROFILE\Menu Add-Ins\My Wizard
Type: 1
ValName: Library
Value: |ACCDIR\MyWizardDatabase.accda
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top