Search results

It's for dev and testing purposes but could be useful for end users also.

Since I only need the COM add-in to load my Access add-in, I'm wondering what the effect will be if I then unload the COM add-in? I guess I'll find out once I put something together. Thanks

I don't know that I need to unload it, and I certainly wouldn't want to unregister it once it's working. I'd just be using it as a launcher for the Access add-in. Any time an Access file is opened, it would load the Access add-in and then be no longer needed until I open an Access file again.

(y) So I just need to put the pieces to put together. Do you have a project file you could provide? I'm using VStudio but I might try twinBASIC and some of the samples listed. Thx

Couldn't the COM add-in be unloaded completely once the Access add-in is loaded?

I assume I need 32 bit version. I'm on Win10 64 bit but running Access 32 bit.

Except, I need a COM add-in to actually load the Access add-in, not just provide a ribbon. Thx

Thanks - I've read about twinBASIC. is there a free version?

So, assuming the Access.Application object is available, I can kick off the the Access add-in from COM. The only thing I would need the COM add-in for is to load the Access add-in. The rest of the code would run from the Access add-in presumably. Sound doable?

Can an Access add-in be loaded from a COM add-in? Yes, the last two. Or at least: when any database file is loaded. Thx

So are you talking about a COM add-in? Perhaps having two add-ins: a COM add-in and an Access add-in. But the goal is to start automatically, and run code. Maybe I would want to open forms in a later version. The other goal is Ribbons that would only show when the add-in is started.

Sure, give me a bit.

Tried that but no dice: the msgbox doesn't fire unless I click the add-in from the Add-ins menu.

I have an Access file that does one thing when it opens: it displays the message "hello". I then install the file as an add-in. When I open another Access file, let's call it Add-in Test A.accdb, the add-in is there in the Add-ins menu but the "hello" message doesn't display unless I click it...

Thx everyone for the suggestions. What I ended up doing is editing the commands in Access 2003, then importing them into the 2016 format file where they end up in the Add-ins tab. I'm also creating proper ribbon buttons for them.

Commandbar Editor looks like a nice tool but it's for Access 2007 or newer :( But Thanks!

There's things I can do - in fact I do them! I'm looking for an easy tool. I thought FMS would have something like this but no. If they want to keep using their dinosaur apps, what can I do? All I can do is suggest.

Yep - it's older than dirt, in fact it's older than some members of this forum I'm sure! Unfortunately, I need to support a ton of old mdb files and thought there may be a tool out there that would help with the toolbar commands.

Access Shortcut (right-click) Tool is useful in Access 2016 but I'm looking for a Toolbar Manager for Access 2003. Everything I've done with toolbar commands has been in VBA, which is not much fun. BTW, anyone know where custom toolbar commands are stored in Access 2003? In one of the system...