by Jack D. Leach | Jun 11, 2017 | JSON, VBA
We work with JSON a fair amount (and honestly I can’t say I care for it too much for anything outside of the JavaScript realm), and when it comes to VBA, there’s next to no support for it. Tim Hall has a great set of tools in his github repo, one in...
by Jack D. Leach | Nov 22, 2015 | C#, VBA
Mostly as notes to myself, I’m posting my general practices for COM interop. General notes: 1) Create VS Solution with (typically) two or more projects: one for the actual .NET stuff, another to act specifically as the COM interface. Core logic, etc stays in the...
by Jack D. Leach | Jul 2, 2015 | VBA
I’ve been using this for the past few months, and I love it… thought I’d share, never really seen it done in VBA before (but maybe many of you do anyway and I just don’t know it!). Visual Studio (2012+ I think), automatically puts a throw new...
by Jack D. Leach | May 20, 2015 | MS Access, VBA
In a previous post I tossed out a concept for a global form handler that could be used to generalize form behavior without having to add any code to forms. After having played with it a few days and hashed a few things around, here’s a refined version of actual...
by Jack D. Leach | May 18, 2015 | VBA
Edit: This post provides the overall concept but not a working code set. I’ve left this post in place and added a new post that contains working code, see here: Generalizing Form Behavior – Refined I have a lot of functionality for forms that I want repeated...
by Jack D. Leach | Mar 1, 2015 | Charting, MS Access, Software, VBA
Download “BrowseEmbed” bemb.v0.5.0.0.zip – 178 KB Where did it come from? I’ve always hated trying to handle charting in Access. The Chart objects that Access provides are ancient and clunky and nobody really uses them because of that, so our...