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….
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. Usually, this is defined when the…
How To Create a Local WordPress site with XAMPP
XAMPP is one of many AMP software stacks (Apache – MySQL – PHP) that can be used to create a local web development environment for design and testing. It automatically installs and configures Apache as a web server so that you can view your pages through http://localhost, MySQL as a database server for website data…
What is Referential Integrity?
One of the fundamental differences between an Excel spreadsheet and a Microsoft Access or SQL Server database is the database’s ability to group data by subject into tables and create links between that information. This type of organization enables the user to store large amounts of data and retrieve specific information quickly by writing queries that…
On Success …
This is my latest Ice Breaker speech that I delivered to the Early Bird Ocala Toastmasters group on November 3, 2018. Toastmasters is a great way to develop your public speaking and leadership skills and there’s probably at least one group in your local area. Check out ToastMasters.org for more information on the club and…
Custom User Controls and Events in C#
One of the interesting features of C# is the ability to add custom user controls to your forms. If you have some specific functionality centered around a group of form controls that you use repeatedly, you can save it as a custom control in a class library and then add it to other applications. This…
Using JavaScript with ASP.NET
Why Use JavaScript? There are a few technologies that you must be comfortable with if you want to do any serious web development. HTML for content, CSS for formatting and JavaScript for dynamic programming are recognized as the three foundation skills that any good web designer needs. ASP.NET programmers might be tempted to do away…
My Virtual Vacation and Free Stuff
Summer vacation has mercifully arrived for me and my students. Unlike many teachers, I’m at the school through most of the Summer. My students get three weeks off – I get one week followed by a couple weeks of what will essentially be teacher workdays. Judging from the sympathetic looks I was getting from other…