Search results

Colin: Thanks. I had suspected something missing in the COM programming underlying the Access.CustomControl class, specifically the absence of an IDispatch events interface in that class. Copilot's longer answer goes off the rails when it says it forwards ActiveX events only to the form...

Can a CustomControl be assigned to a CustomControl variable declared WithEvents? I have an ActiveX control wrapper that successfully binds the ActiveX control and the form to suitably typed variables declared WithEvents. The CustomControl class exposes a distinct set of events, however, so I...

I haven't tried it yet, but there is this.

You're right, of course, on all counts. Errors bubble up the call stack. All that's a given. Note the rest of the post to which you responded, which describes why Canary > My.OnReset is not concerned with error handling. I have been implementing global local error handling for years. This...

I'm not the only one, it seems.

That's actually quite interesting and thanks. I hadn't thought about module-level error handling. I'll need to noodle a bit on what that might look like. You're also entirely correct that what one calls from an error handler is up to the developer. I also mis-spoke a bit. I said it's about...

True but TempVars cannot contain objects. Canary > My.OnReset is concerned with runtime state, not data or even error handling. Jailbreaking event processing and moving it into a standard module is the mechanism.

All true, and thanks. Canary > My.OnReset isn't at all about error handling, however. It's about moving event handling into a standard module.

@isladogs, you're quite kind and thanks for responding, but I actually would invite negativity, most of all from you. None of us have any hope of learning anything otherwise and my ego will be quite unaffected. Two points on this, one related to the event framework and another regarding the...

Thanks for your thoughts. You're correct that frm.Canary.Form_Unload() triggers the event. Pressing the square VBA reset button triggers the event overtly. I also typically have universal error handling in an app, and certainly have it in my base library. I don't currently use vbWatchdog...

The Access.Application class has no events, unlike the Excel.Application class, so Access users are left to their own devices. The most critically important application behavior occurs on a project reset because this instantly and thoroughly disables an Access application, clearing all its...

Isn't there a rule against porn on this site?

Interesting. Looping with a passback. Because its arguments are identifiers, or am I all wet?

Of course, and there also is the "Windows Sandbox," which seems to be a "VM-lite," although I haven't had reason to look into it until now.

That's the obvious safe route. I worked extensively with VMware on Linux for more than a decade, so that's familiar ground. VirtualBox is quite similar. I've known of Proxmox for years but haven't had hands on. It looks preliminarily as if VMware Player, the free version of Workstation...

Thanks. The VM approach is, of course, the most iron-clad solution. I'm currently running Windows on bare metal, so don't for the time being have the (relevant) hypervisor and VM catalog setup I've had before. It's familiar ground, though, just a bit more friction. I'm pretty certain A2003...

FYI, ******** has posted a teaser on this topic specifically, in recent days.

I am contemplating a temporary installation of A2003 to convert some earlier format MDBs that A2007 et seq. cannot open, to A2003 MDB format, which the later versions can open. It's easiest to do this on my production workstation, on which resides Office 2019, 64-bit. Published sources suggest...

I don't know what it means for a file to "live in native Linux." I do know what it means for a file to exist in a file system, for a file server to provide it to a client, to be opened, and to be executed. An ACCDB can exist without difficulty on a Samba share of a Linux or other filesystem...

We also don't conflate a kernel-based virtual machine with those running on other hypervisors. It isn't a generic term. Used generically, it is ambiguous.