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 seemed to have a good community…
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 to make adjustments to the table…
New Video Series – Microsoft Access: The Nickel Tour
My new series of YouTube videos is an introduction to Microsoft Access for absolute beginners who have never used Access before. If you are in the position of needing to learn Access fast or are curious about what you can do with Microsoft’s desktop database software, this series will provide you with a great introduction…
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 settings that needed adjustment but after…
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 close of the gradebook but it’s…
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 out on the road and the…
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 basic tools in Access is 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 quickly create a new self-contained instance wherever…
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 the other one. JobSearch Plus was…
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 of information to look through anyway.…