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-594c1184b8979592496716/] To use, something like this: [crayon-594c1184b8983215578118/]
Read More

NotImplemented()

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

read more

Azure Series: 04 – SQL Database

[wpdm_package id='802']   SQL Database (Formerly called SQL Azure, the official name for this service is specifically “SQL Database”).  We know a bit about users, accounts and resource groups, so let’s get our database up and rolling.  Open up the portal...

read more

Azure Series: 03 – Getting Started (Resources & Services)

[wpdm_package id='787']   Getting Started (Resources & Services) Now we’ve got user stuff more or less squared away (or at least have something shaky to stand on…), let’s get into the fun stuff… resources and services. A service is pretty self-explanatory.  A...

read more

Azure Series: 02 – Getting Started (Accounts & Users)

[wpdm_package id='781']   Getting Started (Accounts & Users) To get started with Azure, we’ll need to set up an account and at least one user.  While it’s likely that we can get through the basic steps of doing so easily enough without much guidance, the...

read more

Azure Series: 01 – Intro to Azure

[wpdm_package id='749']   I’ve been using Azure to handle LOB and SaaS applications for some time now, and without doubt it’s a massively powerful, expansive and complicated system.  The aim of this series of posts is to provide an introduction to the Azure...

read more

Generalizing Form Behavior – Refined

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

read more

Generalizing Form Behavior

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

read more

Database Performance for Non-Databasey Devs

I had a junior dev (primarily front-end web) work on a site for me that included a couple calls to the underlying database.  Upon reviewing the work I decided to make a change to the way that some of the DB calls were handled.  Below is the explanation of why I made...

read more

Access vs. .NET Development

I got involved in a discussion a few weeks ago with someone who was pondering why - generally speaking - a competent Access application developer tends to have a lower pay range than an equally competent .NET application developer.  My initial response was "well hey,...

read more

browseEmbed – HTML5/JavaScript for your Access projects

browseEmbed Home Page QuickStart Guide Documentation [title size="2"]Where did it come from?[/title] 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...

read more