Add_in - Access 2000

[PeterS]

I have created a Com Add-in in Visual Basic 6 for use in Access 2000. The Add-in is intended to insert error traps in code. I have been using one in Access 97 for some years and it is a great little tool.

My problem is that I can't seem to be able to get the Add in Manager in Access 2000 to see the new dll which comprises the new Add-in.

Maybe I am approaching the problem in entirely the wrong way. Can anyone point me at an article or some other publication which deals with Add-ins in Access 2000.

I don't have Developer Edition of Access 2000, in which case I believe, I have to use VB6 to build the Add-in.

 

[scking]

You don't need to use VB6 to build the add-in.

Make a USysRegInfo table using the following format. Obviously my add-in is called 'Bug Manager' and I call it through an sck_Initialize function. Name it with an .mda extension and put it in the access default directory. There is a lot more to it than this such as using CodeDb vs CurrentDb but most of this will have to be learned.


Subkey Type ValName Value
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\8.0\Access\Menu Add-ins\&Bug Manager 0
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\8.0\Access\Menu Add-ins\&Bug Manager 1 Expression =sck_Initialize()
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\8.0\Access\Menu Add-ins\&Bug Manager 1 Library c:\Program Files\Microsoft Office\Office\BugManager.mda
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\8.0\Access\Menu Add-ins\&Bug Manager 1 Description Application to aid developers manager defects and track their status though to completion.

Steve King Growth follows a healthy professional curiosity