BLOG

Parsing JSON with VBA

This is a quick posting in accompaniment to the slide deck and presentation from PAUG for web service work. Module JsonParser: [crayon-594c0a2bc18f2213306723/] To use, something like this: [crayon-594c0a2bc18fb682110474/]
Read More

Considerations for 3rd Party Service Integrations

Often times when looking into software solutions, we may consider building a complete solution from the ground up versus making use of 3rd party services to cover the basic requirements in conjunction with some possible custom integration(s) between those services....

read more

Intelligent Data Generation?

I always hate having to generate test data... even with tools like Red Gate's SQL Data Generator (which I use liberally when I need to do such tasks), there's always a bunch of screwing around that needs to be done to get everything as tied up as neatly as possible,...

read more

Web Work with VBA

It seems like a good portion of the posts zinging my radar over at UA these days are people asking how to deal with a) web service calls in general, and b) JSON.  As usual, I get tired of writing the same replies for generic answers, and wind up writing a blog post....

read more

Keeping Secure Info from Source Control

(more self-reference stuff, notably in visual studio, but the process is similar regardless of platform - this is a various collection of resources not meant to be used all at the same time) Basic steps (not considering more advanced setups such as Azure deployment,...

read more

.NET COM Interop

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

read more

Azure Series: 05 – Database Performance

Database Performance Gaining acceptable performance with client applications against a remote backend involves somewhat of a paradigm shift compared to how we're used to developing desktop applications in local client/server environments. This latest post in the Azure...

read more

Async Processing in Access

[wpdm_package id='824'] I've been wondering for a while how to go about running async tasks within Access.  The lack of multi-threading support has always been something I wished was available, but not until relatively recently when dealing with Azure backend...

read more

Folder Context Menu for the Git shell

Now that I've had to do it on a few computers, I figured I'd jot it down here so I could find it easier in the future (and maybe someone else can make use of it). I'm not a big fan of the GUI stuff for Git, so it's easier for me to open the shell and do what I need...

read more

Highlight the Current Row

Using a continuous form, Conditional Formatting and VBA, we can easily give a visual indicator of the currently selected row. This example sets the ID field as Bold for the current row, but this can be applied to multiple controls. A common approach is to make a...

read more