Recent content by riktek

If I understand correctly, you're describing a library interface class implemented and instantiated by referencing projects' classes. My problem differs, I believe, because it involves the library calling code in the referencing (i.e., front-end) project. As I noted in response to another...

If I understand correctly, this still contemplates the front-end ribbon calling the library function. My problem is getting the library to call the front-end function. The library code in question is a framework of object wrappers sinking front-end object events. E.g., if I double-click on a...

The difficulty is that that table must exist in the referencing project or its back end because it is specific to it, and it would need to be visible to the library project's code in the same way.

VBA succeeds in boxing out the notion of an entry point other than a document in a COM app, in a variety of ways. One can get close by understanding event progression but even it has constraints. It is fairly liberal about passing objects, if not initializing them, and the object model...

Yes, of course, just for starters. I'll sacrifice orthodoxy for function but it seems to me this is the road to perdition. There is no difficulty in designing an object to accept parameters, however, including the identity of the referencing (or instantiating) object. Or, for that matter, to...

I've been refactoring a number of projects and migrating generalized code to a library ACCDB over time. It's gone practically without a hitch and many ACCDB projects reference it and instance its classes like a charm. As this refactoring has progressed, I have encountered one difficulty...

Colin, you're a font of knowledge. More than I can bite off on this instant but I've just bookmarked those of your pages I hadn't already. Among other things, the NavPane code addresses an item on my development plan. I've already settled on the SendKeys approach for A2007 contexts and had...

You're right about F11, my mistake. Ctrl + F1 is what does the trick. I'll edit my original post presently. I am actually working on 2007 for present purposes. Its ribbon implementation not being ready for prime time as you say explains much, not only the fact that the ExecuteMso method...

Exactly.

Big thanks for getting back. As noted, I've tried both commands and both have failed. The DoCmd command hides everything, including the QAT and even the Application Title. It's the nuclear option for wiping half the GUI and nothing less. Clearly not an option. The CommandBars method fails...

Thanks for getting back. The Menu Bar is the menu bar, the part in the red that has menu items. In code, its name is "Menu Bar", at least according to the values the CommandBars object returns The Ribbon is the Ribbon, the part in blue with the iconified controls. In code, its name is...

This is well and extensively discussed elsewhere but nevertheless all of the posted "solutions" fail and I am unable to programmatically minimize the ribbon but not the menu bar, as one can do by selecting the Menu Bar context menu's "Minimize the Ribbon" item (or pressing Ctrl + F1). To be...

Thanks. That's quite kind. I'll do a more deliberate search. I'm actually familiar with a few of them, though. A friend who implements a similar subclass framework actually sparked my idea when he implemented one of those solutions in his framework.

Just experimenting with adding functionality.

That's all the time I'll need it. I don't think I'm going to get the hWnd via VBA other than calling for it in the right event procedure. For a Section, that's probably Paint, chiefly because sections don't have any other events, except for things like Click or DblClick. Beyond that, what I'm...