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

Coming in 2019 – CodeScholar Software Development Training!

A simple Google search turns up hundreds of options for learning programming, many free, but where do you start?  There are many excellent reference sites and YouTube channels out there but many focus on the mechanics of a single language without explaining the broader concepts and best practices. Many are written by developers...

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

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

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

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

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

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

The Accidental Teacher

The following is the text from my speech to the Ocala Early Bird Toastmasters on May 19, 2018.   My name is Andrew Comeau and I am … a public school teacher? I say it that way because It’s been a study in irony for me. If you told me...