Search results

"Namespace" is reserved in VB.NET but is not documented as such in VBA, as far as I can tell. VBA bucks a bit when I attempt a "Public Property Get Namespace()" but seems to take the bit after compiling, saving, and cycling the app a few times. Lest I court disaster and before I go too far...

Perhaps but if so, she ought to be able to respond substantively rather than ad hominem. It's an interesting presentation but I've also studied event progression with equal or greater rigor, so I do, too. Perhaps she might learn something if she paid attention, read closely, and weren't so...

No disagreement but that is beside the point, which is that it isn't clear from the OP that the parent record, or form, is in question. He said the "main form," not the "parent form," was on a tab page. A tab control's parent can't be on a tab page. Common usage of course is that "main form"...

This is a reasonable expectation, as is the case with forms, and the documentation suggests this, as you say. Nevertheless, I have found it not to be case on several occasions. In the universe of controls. My specific findings are that Activate and Deactivate do not occur for subforms...

I departed A2007 at long last and now, on A2019, find that my apps' record selector backgrounds, scroll bar backgrounds, and scroll bar thumbs all are solid black. I've been rooting around fiddling with Windows, Office, and document themes and sundry registry settings, with no effect and Google...

Controls' Before and After Update events often do not occur, the documentation notwithstanding. Similarly, Form.Current and Form.Activate do not occur for subforms or pop-ups. The language describing controls' Change and Dirty events is identical but Dirty occurs only with the first change and...

Events occur when they do but sometimes not when documented. When conditioning code on them alone, the best one can do is to better understand their triggers and how to avoid them or make them happen, or to find another event, which often will be for another object. Updates can be triggered...

For <$1.00. LOL.

I did, of course. Amazon's, and Best Buy's, fine print are as described. Good to know Access is included notwithstanding the fine print but I'm reticent to drop $100 or more on a nonrefundable purchase on the expectation that undocumented features are included. To the point, though, I'm still...

That's curious, because on Amazon just now, in the U.S., at least, it isn't included in the Home, Home & Business, or Family 365 (subscription) versions. My recollection is that it hasn't been, for years, at least according to the listings. In each case, they're limited to Word, Excel...

No Access in the "Home" version, IIRC. I've done "bitness" Windows VMs before using VMware (on Linux but it shouldn't matter) with zero cost other than time and storage space. Quite helpful for running simulations back in the day when 64-bit MSO was considered experimental.

Understood but that's why I suggested a dm. Spill. ;-)

I have been experimenting with one of these volume license keys (also for 2019, it turns out) and can't get it to work. I've tried running setup.exe with and without a configuration.xml file, with media from varying sources, and in all cases get the error "This product key is for the...

Out of curiousity, could you share (here or by dm) which vendor you used? I'm attempting the same upgrade path (i.e., 2007-2019) but the key and media I got don't play well together, so I'm looking for alternatives.

There definitely are several ways to skin this cat. Most are form-specific, which I'd like to avoid if possible. Intuitiveness, if that's a word, definitely is in the eye of the beholder. Getting one's head into the Apple UI metaphor (or GNOME, for that matter) helps a great deal and not...

Colin, I've always found you to be quite clever and this approach makes a great deal of sense for many reasons. Throw in some anchoring and resizing and even more so. I'll need to re-engineer how I re-set the link fields properties after Access reconfigures them sui generis when the source...

Somehow, I can't get the Click event to fire at all. DblClick fires when done on the vacant portion of the tab row.

Thanks. I'm familiar with the object model. Double-click events occur for all objects and work normally. No Click event occurs for the tab control when clicking on either the tab itself (whether active or not) or in the vacant area of the tab row. The DblClick event does not occur when...

Thanks. A transparent command button would seem to be the extent of available solutions, or perhaps relying on TabControl.DblClick and clicking in the space unoccupied by the tabs. To your question, "why do it?", the idea is to have a generalized behavior such that the double-click on an...

In the realm of stupid questions, but I've not had to do this before and my Google-Fu has failed me: Which, if any, event occurs when one double-clicks on a TabControl object's tab, perhaps otherwise referred to a Page object's tab? More specifically, on the active tab / tab for the active...