Managed code add-in for Access

[MacDermott]

I'm trying to write my first managed code add-in to use in Access.
It compiles in VS2003, but I get an error message about the QueryInterface
when I try to open Access.

I asked a question in microsoft.public.dotnet.framework.interop, but got no
interest, so I thought I'd try over here.
If anybody here has experience with this, I'll be happy to post details of
the problem.
Or if you have an idea of a better group to ask in, I'd welcome that, too.

TIA
- Turtle

 

[OldPro]

I'm trying to write my first managed code add-in to use in Access.
It compiles in VS2003, but I get an error message about the QueryInterface
when I try to open Access.

I asked a question in microsoft.public.dotnet.framework.interop, but got no
interest, so I thought I'd try over here.
If anybody here has experience with this, I'll be happy to post details of
the problem.
Or if you have an idea of a better group to ask in, I'd welcome that, too.

TIA
- Turtle

I am also attempting to make an Add-In for Access. Have you tried
installing a less complex version to see if it works? This may tell
you where the problem lies.

 

[MacDermott]

Wow!
I looked back over the code (which I'd copied verbatim from a magazine
article), realized there were some problems with the declarations, and Boom!
It started working!

One problem left -
I want this new button to show on the toolbar in the VBE.
It shows up great in the Access window, but disappears in the VBE.
Any ideas on that one?

TIA

 

[MacDermott]

OK, figured that one out, too!

In case anyone cares, I had to use
applicationObject.VBE.CommandBars("Menu Bar")

instead of

applicationObject.CommandBars("Menu Bar")