Things I Learned About CiviCRM This Week

I was introduced to CiviCRM a few years ago when a new customer needed a replacement for an old poorly designed database solution and needed it quickly. After getting quotes starting at $10,000 for systems supposedly designed for non-profits, I stumbled on CiviCRM which was free, open source and...

Deploying MS-Access Table Design Changes to Remote Files

A New Challenge for Access I designed a Microsoft Access database for one of my clients and it’s split into two files – a front-end file with all the forms, reports and code and a back-end file with the tables. That’s pretty standard. During the development process, I needed...

Unboxing the Unitek IDE / SATA to USB 3.0 Drive Adapter

I hoped it would be a simple fix when the customer asked me to look at her Windows 7 machine this week. I don’t really do PC repair anymore but I have one or two old customers I’ll help out when needed. I figured it was just some Windows...

Calculating Mortgage Payments in C#

For my students’ final project in their current course, I decided to have them program a small C# program that would calculate mortgage figures and compound interest results.  That description doesn’t really do justice to the horrors I visited on these pour souls during their final week before the...

Unboxing the ASUS Chromebook

This past weekend, I finally decided to spring for a Chromebook. I’ve been thinking more and more about a Windows replacement machine, at least for basic tasks. I also wanted an inexpensive solution that would extend the life of my current laptop. I often don’t need the full machine...

Helping Users Work With Subforms in Microsoft Access

Creating an Access application for other people means anticipating how the users are going to interact with your program. Without clear direction from the program or you, users can be easily confused by even simple things like the order in which data is to be entered. One of the...

How to Perform a Basic MySQL Installation in Windows

One of the nice features of MySQL as a database software is its noinstall option in which you download the files themselves and perform a manual installation that takes just under a gigabyte of space on your drive.  If you’re a developer or a student, this means you can...

How to Programmatically Relink Tables in Microsoft Access / VBA

Several years ago, I designed a Microsoft Access application called JobSearch Plus for managing job leads during an employment search.  It was a split application, meaning that the tables were stored in one Access file, the back-end, and everything else was in the front-end file with table links to...

How To Create a Dynamic Search Filter on a Microsoft Access Form

Best practice when retrieving data in Microsoft Access or any database, for that matter, is to limit the amount of data that you pull at any one time. This means using the proper filters and limiting the number of fields retrieved.  Often, you still end up with a lot...

How to Dynamically Set the Report RecordSource in Microsoft Access

One of the steps for creating a report in Microsoft Access is to define where the data is coming from.  This is done through the report’s Record Source property which can be a table or standalone query in the database or a SQL statement as shown in the screenshot below....