sistawendy | I despise Microsoft Access.

Yeah, I had to go back to (the temporary location of) Lambert House and fix the stupid UI, which is is written in Visual Basic for Applications. And what did I have to fix?

The stacking order of UI elements, which gets messed up every single time I touch them.
Actually do the plumbing from Access's pidgin SQL to VBA. How pieces of data get from the former to the latter isn't exactly obvious. It's the seam that holds Frankenstein's head on.
Figure out why the check boxes weren't checking. The answer here was that if you want to check a box you have to click about 1mm to the left of the box. That's right, there are arithmetic errors happening way down deep in a UI library, and they'll never be fixed because they've been unsupported for years now.

So what's the really right way to fix this? Move to a real SQL server and write a front end. It wouldn't even take much Javascript to do what Lambert House needs. But that's a big-ass project, and one that I've already tried and failed to sell to Ken the director. Welp, if things ever really go sideways I'll be doing that project in a big hurry. Maybe I should engage in speculative execution.

I got home after 10:00 last night and slept the sleep of the just.