Search results

I hadn't thought of it that way. Probably because this doesn't seem to require more than the thinnest and least removed degree of indirection to accomplish, or even qualify as such. I'm surprised at some level that this might be so because of how the function is defined and described - give it...

I would like to programmatically construct a constant's name and return its value, but am stuck. Eval() seems the most logical approach but it chokes, as follows. At the top of a standard module, I do, e.g.: Public Const conFooBar As String = "conFooBarValue" Then, in the same module a...

That could be it, too. No telling how the organization allocates tasks and responsibilities. Access class modules are a class in the Access library, however, not just generic VBIDE.VBComponent objects. Access.Class is hidden but it's what exposes the Initialize and Terminate events. No VBA...

I just confirmed @sonic8 's observation that the code in Form_Unload() and Form_Close() event procedures will run after a project reset even though code in Class_Terminate() does not. For the test, I simply revised the containing variable's type declaration from Access.Class to Access.Form and...

Yes, of course, and I do so in a standard way practically everywhere. This actually has more to do with fundamentals bearing on some framework extensions I'm evolving concerning events. Access.Class.Terminate is just a piece of a larger puzzle. @sonic8 's observation about Form.Unload and...

Yes, of course, but the question really is, then, what? Destroying a variable containing a class instance will destroy the instance. So far, so good but do this manually and Class_Terminate() executes, do it with a reset and it doesn't. The consensus seems to be that a reset (or an End...

I'm mostly seeking to confirm my understanding but the question is whether Class_Terminate() runs on or immediately after a project reset. I don't think so. Some sources (including LLMs) state otherwise, however, equating a reset with clearing the sole variable containing an instance of a...

I just ran across this, so sorry to be late to the party. Colors in Windows are a shit show™ although, to be fair, GTK also qualifies. Happily, not so much with the VBE, I learned. We can tinker with these settings in some (but not full) detail via the GUI (Tools > Options > Editor Format)...

You can still love it, and use the present tense, because it continues to exist in the new/current WordPerfect.😁

I've had other fish to fry, development-wise, since proving the concept but WordPerfect actually is brilliant as a report writer for Access. One simply does a merge into what is essentially a template document. I don't know that I'd necessarily draft documents programmatically with either...

We discussed briefly my idiosyncratic automation of WordPerfect from Access at the AE session a couple months ago. I simply don't automate Word. It never has been stable enough for documents more complex than simple memoranda. As I got more into programming, I realized its object model is...

Wow. Thanks for that, too. One often enough is made out to be a fool or incompetent when posting about anomalies (thankfully, not so much in Access-specific fora) and seldom acknowledged. I'm not holding my breath. Pending resolution, it does provide some license for ridicule, however. Not...

@sonic8 , I thought I had responded the other day but I must not have clicked "Post reply" because it doesn't appear. Apologies, and trying again: We thought so, too. I can't provide the other developer's code directly and mine is embedded deeply in an application framework that can't be...

@isladogs , thanks for your attention and taking the time to report this behavior. I did tinker with the TabControl.UseTheme property in A2019 and toggling it does indeed toggle the mis-centering bug. Quite odd because no obvious connection or relevance exists other than being in the context...

Do I understand correctly that you want to evaluate an existing COM DLL to learn whether it can be used in VBA? Or, do you know that you would use the DLL if it only it could be made COM-consumable, but aren't sure whether it is? Many stock .NET COM DLLs expose only their classes and none of...

In order: - MSO Professional Plus v2506, build 19825.20138 Click-to-Run - US-English - EngraversGothic BT, in which lower case characters seem like small caps. - I bind tab controls (and other controls) to a control-specific superclass / control wrapper. The tab control wrapper sinks...

It was another developer's code, actually, so I can't directly. He was spawning custom message box forms in A365, though, popups but not modal or dialogs. While clearing references in his 32-bit apps continued to work, a client of his flagged that in 64-bit, those forms began remaining open...

Quite interesting. You've replicated the behavior exactly, for starters. Agreed that it's not quite right justified. Perhaps better put, the caption text seems to begin at the center (instead of being centered). Also, it's quite odd that UseThemes should bear on this but who knows. I do...

A few of us were putting heads together the other day to resolve some difficulties around closing form instances and I thought I'd report back. What's new recently in the experience of several of us is that apparently, clearing a reference to a form instance is no longer sufficient to close...

I'm noodling a bit on how the labels approach might substitute for a page with many subforms, but that's admittedly a special case. I have navigation baked into my application framework, that handles moving among forms and records. See here. AutoKeys can be handy to open forms in the first...