Recent content by riktek

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