Creating an Access Add-In

giacomo

Well-known Member
Joined
Feb 20, 2002
Messages
1,796
I have a utility that I would like to set up as an add-in. I saved the file as a .mda and put in the same directory as Access. I set up my USysRegInfo table with the following values (I'm using Access XP):
Book1
ABCD
1SubkeyTypeValNameValue
2HKEY_CURRENT_ACCESS_PROFILE\MenuAdd-Ins\Finder0
3HKEY_CURRENT_ACCESS_PROFILE\MenuAdd-Ins\Finder1Library|ACCDIR\FNDR.mda
4HKEY_CURRENT_ACCESS_PROFILE\MenuAdd-Ins\Finder1Expression=FNDR_INSTALL()
5HKEY_CURRENT_ACCESS_PROFILE\MenuAdd-Ins\Finder1Version1
Sheet1


=FNDR_INSTALL() creates a new toolbar, this works fine, it loads up as soon I import in through the add-in manager.

The problem is that the button on my toolbar is supposed to open a form, but it doesn't instead I get an error: "The expression you entered has a function name that access can't find." I've tried adding the code that opens form into the working toolbar code but the form still won't open.

If there is anyone out there with experience creating add-in's I would appreciate your help. I've already been to the MS knowledge base, but am still having trouble.
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Forum statistics

Threads
1,221,691
Messages
6,161,310
Members
451,696
Latest member
Senthil Murugan

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top