Search results

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...

I'm actually evaluating Kent's technique for implementation in my own framework. In that vein, I'm wondering elsewhere how to get the hWnd of the Detail section for the current record in continuous forms. Dev Ashish has posted code to do this for controls, which is handy for scrolling text...

Thanks for your thoughts. Re GotFocus, the point simply is that, in the Access object model, "Focus" doesn't go to a form with controls. So, to the extent that Windows evaluates "Focus" in the same fashion, the Win32 GetFocus function may not return an hWnd for the form or one of its sections...

I'm noodling on extending or tweaking the mechanism behind scrolling text in text boxes, to address a form's Detail section, especially while it is in Continuous Forms view. Apparently, Windows regards a TextBox to be a window. As such, it has an hWnd. Dev Ashish's widely circulated code...

I actually developed a fix that allows text box scrolling without scrolling records in continuous forms. When Access scrolls records in continuous forms on the MouseWheel event, it obviously just sends a Scrollbar message to the form. There aren't any hooks into that behavior but nothing...

Thanks to all for the input. I've since learned that the form event reiteration is a consequence of binding the form to the form property of an instance of a form wrapper class. That would seem to move focus to the class instance sufficiently to trigger the Deactivate event. So, the means to...

Thanks. I know. Thanks. I know what an event is. Thanks, I understand how Access works. Thanks. I know. Correct. That's why we write code.

Thanks. I wasn't posting links, actually. I think the problem was excessive quoted text from the posting I was replying to.

Thanks to all. I'd respond in detail but the interface rejects my attempt to post my findings on the grounds of being spam-like, whatever that means. Briefly, I discovered the causes of the event progression and the means of interrupting it in both cases. I'll revert if permitted.

Simply by avoiding the things that trigger the events, of course.

Thanks for the input. More findings, as follows: The first question actually concerns a bound form with no subform, bound or otherwise. That is, why on a simple form with only combo box and text box controls, do Activate and Current reiterate, seemingly contrary to all documentation...

This question is either dumb with an obvious answer, or arcane and deeply into the weeds, I'm not certain which, about event progression among forms, subforms, and controls. Of course, I already have made extensive reference to the Access object model and the MS article Order of Events for...

I'm Eric and have been developing in Access for ten years or so internally, and am debating going pro. I'm based just outside San Francisco and balance interests in running, mountaineering, fine cuisine, and shenanigans.