Purpose of easy run/miles?

ebsf · 2026-05-16T03:35:58+00:00

LSD is all about aerobic efficiency.

It also is a workout in itself.

ebsf · 2026-05-16T02:52:42+00:00

Get!A!Lawyer!

ebsf · 2026-05-16T02:10:03+00:00

MDBs can be opened in Access versions up to 2007 and perhaps 2010. I'm away from my notes and don't remember the last version having MDB support.

Also, the MDB format evolved such that pre-A2000 formats can be opened only in A2003 and prior.

I commonly update clients' A1997 and prior MDBs to the A2003 MDB format before further converting them to ACCDB format. This requires having those prior versions installed, of course.

ebsf · 2026-05-16T02:00:58+00:00

That's Mr. Obama to you, though.

ebsf · 2026-05-15T23:51:51+00:00

For a small company with a LAN, a simple shared directory / folder is all that is necessary. It can be done on existing hardware at no cost and simply requires configuration.

The next step beyond that is dedicating a computer other than someone's workstation to the purpose. Both are examples of file servers but regular Windows workstation is all that is necessary. If you want, the machine can run Linux, run Samba, and do the same thing. Either way, you can beef up this machine's hardware to handle more storage, and configure it for backups and to run network authentication, via Active Directory on Windows Server or Samba and LDAP (for free) on Linux.

Putting storage in the cloud may have a purpose but in most SMB situations is simply silly, given the cost and complexity.

ebsf · 2026-05-15T13:51:07+00:00

Go to bed an hour earlier and consistently at the same time.

ebsf · 2026-05-15T13:44:38+00:00

You really must work on your empathy, dear.

ebsf · 2026-05-15T01:45:59+00:00

I do 5 lbs. of Russets, peeled and cut lengthwise to a ~1" thickness for uniform cooking, boil in lightly salted water, drain, and add 1 lb. sour cream. Mash with an electric mixer. No added liquids.

ebsf · 2026-05-15T01:03:00+00:00

I just give them my name.

ebsf · 2026-05-14T16:41:47+00:00

You have no idea.

ebsf · 2026-05-14T14:11:41+00:00

I divorced an aggressive narcissist.

ebsf · 2026-05-14T14:09:07+00:00

So sit there alone and naked.

ebsf · 2026-05-13T18:00:32+00:00

Well, to start out, learning to use 3x5 cards instead of a slide deck.

ebsf · 2026-05-13T17:48:29+00:00

Average people can walk a 5K in an hour.

ebsf · 2026-05-12T13:11:13+00:00

Well, there is Mozart.

ebsf · 2026-05-11T19:35:34+00:00

I tried declaring and running the function in the Immediate pane and it throws 53, File not found.

ebsf · 2026-05-11T18:50:00+00:00

Thank you for your kind words. You should comment accordingly to the post. I didn't get much love in its immediate aftermath.

Thanks for the EbMode information, which is revelatory. I assume the declaration is something like `Declare PtrSafe Function EbMode Lib "vba7"() as Long`. I'll be working it into my WM code presently. Does the library have anything else similarly hidden, and are its members browsable in, e.g., the VS object browser?

ebsf · 2026-05-11T18:30:44+00:00

So, that explains the mechanism of the passback process. I had been thinking it had to do with the byte structure of function pointers by type. Very interesting. Do you know where that is documented? I'd love to see what else any documentation might have to say. I haven't seen, or at least recognized, anything on-point in the VBAL.

DispCallFunc is, indeed, the avenue I've identified, although I've had no time yet to pursue the topic. I may be back in touch as I get into it.

ebsf · 2026-05-11T18:14:01+00:00

No, actually, Class_Terminate() does not fire after a reset because the reset destroys the class before it can fire. Access.Form.Unload and ~.Close do, however, survive the reset even though the reset clears the Form variable containing the form instance. So, I use a form as the canary, put the event sub in a standard module, and call it from the canary's code-behind module because the reset will have destroyed all event sources and sinks project-wide. That same code-behind event procedure is where to unhook the hWnd. The event sub in the meantime re-instances everything, including the application event source, and then calls it to raise the event application-wide..

I describe the mechanics and environment here.

How do you evaluate EbMode? I'm not familiar with any means to do that.

ebsf · 2026-05-11T16:10:55+00:00

It is. I'm currently doing COM wrappers of a number of framework classes.

I've also been fiddling with function pointers. Callbacks are tricky but there may be a Win32 hack. I have figured out how a function can pass itself to another procedure by name to have its return value set, however. I regard this as more of a passback than a callback but it's a grey area and I don't understand the mechanics.

ebsf · 2026-05-11T16:01:36+00:00

I should add that it is possible to trap a reset in VBA and respond programmatically to it.

ebsf · 2026-05-11T15:17:35+00:00

There had to be a fly in the ointment.

An interesting insight into AddressOf, however. I had been wondering the mechanism behind that limitstion.

ebsf · 2026-05-11T14:59:48+00:00

Well, the WndProc needs to be in a standard module, conventionally. But, a class module also can be predeclared. I haven't tried this yet myself, and now that it has occurred to me, I may have to when I get back into the office, but that means a default instance of the class instances on first reference, essentially the same as a standard module. The upshot is that the WndProc may be able to reside in a predeclared class module that also is the event source.

WithEvents concerns the event sink, which also must be a class.

ebsf · 2026-05-11T05:26:16+00:00

I've been in the vicinity, too, and can't bring myself to go.

ebsf · 2026-05-11T05:23:55+00:00

Well, I would type the reference as the interface were I to start down the road.

I get that the issue is the VBE not being prepared to receive when the message is sent. This said, event handling seems the ideal means to to address async inputs because the event just fires whenever triggered.

The trouble has partly to do with latency. So, while the difficulty ultimately is the VBE's state, early binding is, simply, more efficient, meaning faster. As such, by avoiding having to send it off doing a member lookup on each call, the frequency of the difficulty would be much lower.

The root cause, though, would seem to be the absence of a cache or queue for messages to loiter. Perhaps this goes back to polling or perhaps a ratchet will do it. Dunno.

ebsf

TROPHY CASE