Category Archives: How-to

Check out our online courses!

Sharing knowledge has always been the purpose of this site and now, Comeau Software Solutions has its own collection of online courses through Teachable.com!

Early in 2020, I started designing some video-based courses and posting them on YouTube and Udemy.com. Now you can find all current and future courses through my new online school on Teachable.com.

Teachable schools are great tools for online instruction. As a Learning Management System, Teachable hosts the content and provides a user-friendly environment that you as the student can easily navigate. You can learn at your own pace and provide feedback to me as the instructor. For paid courses, it also provides a safe and reliable checkout system that you can trust.

Continue reading

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 subform which allows for the input of records related to a master record. A classic example is a database which stores customer orders and where each order might have multiple items (i.e. order lines) associated with it.

Continue reading

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. That’s when it can help to have a dynamic search filter that will enable you to easily search the records with just a few keystrokes.

One easy way to do this is use the form’s Filter and FilterOn properties along with the KeyUp event as shown here.

Continue reading

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 report is created and only gets changed if needed.  In some cases, however, you might want to use the same report object for many different queries.  You could have a mailing list report that you want to use for employees, customers or other groups at different times and the data would be drawn from different tables or even different databases.


Do you need help with Microsoft Access?

Comeau Software Solutions specializes in the development and enhancement of Microsoft Access applications. We can also rescue Access projects that have gone off-track and help you decide when it's time to move to another solution. Please contact us for more information on how we can help you with your database needs.

Also, check out our online course Managing Your Data with Microsoft Access. You can learn how to build and manage your own applications and work with your data more efficiently!


Continue reading

Performing a Basic Install of MySQL or MariaDB in Windows

One of the great things about MySQL and MariaDB are their versatility of installation. They can be setup as a Windows services and trimmed out with some extra utilities or it can be installed on a flash drive as a portable server.

The easiest installation is certainly the Windows Installer with a wizard for MySQL or the MariaDB MSI that will guide you through the installation of the server and all the options you want.  Myself, I still like self-contained programs that won’t interfere with anything else on my system and can be easily removed without leaving hidden traces. I also don’t like adding a lot of stuff to my Windows startup.

If you have a basic comfort with using the Windows command line and control panel, doing a minimal installation of either MariaDB or MySQL is not difficult once you understand a few steps. The MySQL full documentation and the MariaDB Knowedgebase are available for reference on their respective sites but here are the essentials to get you started.

Continue reading

Windows 7 Update Gets Stuck While Looking for Updates

Windows UpdateAfter doing my year-end rebuild of my Windows 7 system, I went ahead and did a check for updates, preparing to wait for awhile as there were currently over 150 important updates for my system even after installing SP1.

So I waited … and waited … and waited some more.

After a couple hours, I knew something was up so I started searching for solutions. Finally I found an update that took care of it; an update was needed to fix the update process.

KB3135445 – Windows Update Client for Windows 7 and Windows Server 2008 R2

To apply this fix:

  1. Restart your computer. I prefer to do a complete shutdown, wait a few seconds and then start it backup.
  2. To be safe, disable any anti-virus programs you have running. This update might not work if they’re active.
  3. From the above link, download the version of the fix that’s appropriate to your computer.
  4. Double click on the file to run it and follow the prompts. The installation process is short and simple.
  5. After the update finishes, restart your computer again.

When you run Windows update, it should now find any available updates within a reasonable amount of time.

If that update doesn’t fix the problem, there are a couple of others that I found out about when dealing with this problem on another machine.

KB3020369 – April 2015 servicing stack update for Windows 7 and Windows Server 2008 R2

KB3172605 – July 2016 update rollup for Windows 7 SP1 and Windows Server 2008 R2 SP1

Again, be sure to disable your anti-virus software when installing these and possibly when checking for updates as well.

Adding Passswords to Microsoft Access Switchboard Options

The Switchboard Manager in Microsoft Access makes it easy to create a system of menus that will enable your users to navigate through your application. It also relieves you of the need to manage multiple menu forms and macro calls.

Microsoft Access switchboard form
Figure 1 – Example Access Switchboard

Sometimes, however, you might want to keep all but a few users out of specific areas, even if it’s just a password to discourage the curious. This is one thing the Switchboard Manager doesn’t offer and I’d like to show you one method for achieving this here. I want to stress that this method is not truly secure.  On it’s own, it won’t prevent a user from hitting F11 and browsing through the database. A power user who wants to see those areas could defeat this method pretty quickly. It will keep the merely curious and inexperienced users out, however, and could be combined with other measures to add more security.


Do you need help with Microsoft Access?

Comeau Software Solutions specializes in the development and enhancement of Microsoft Access applications. We can also rescue Access projects that have gone off-track and help you decide when it's time to move to another solution. Please contact us for more information on how we can help you with your database needs.

Also, check out our online course Managing Your Data with Microsoft Access. You can learn how to build and manage your own applications and work with your data more efficiently!


Continue reading

A Complete Guide to Installing MySQL and PHP with IIS

Note:  This article was written in 2015 and is in the process of being updated.  It is still useful as a general guide for issues you might encounter in this type of installation. Please take this into consideration when downloading components.


One of my latest projects was setting up WordPress, the popular content management system, on a client’s web server which was running Windows Server 2008. WordPress requires installations of MySQL for the database back-end and the PHP scripting language in order to serve up the WordPress content. On a local Windows machine, I’d probably just use a pre-configured WAMP (Windows, Apache, MySQL, PHP) stack package like XAMPP which is installed quickly and includes all the necessary components. That’s not quite an option in a professional environment, though. I was also working with Internet Information Services (IIS) 7.5 for the web server instead of Apache so the process is a little more involved.

Click here to read more about using XAMPP to create a local installation of WordPress.

Continue reading

On the Importance of Backups and Storage Decisions

Windows 7 installation routine

Re-installing Windows 7 ….

I admit it’s a little bit of a geek thing but I’m in the habit of wiping and reloading my computer systems at least once a year to keep everything working right. I find that, even as careful as I am about what I install, I still work with some major software and Windows systems start to slow down and get a little flaky after awhile with random hiccups that take time to track down. Sometimes, it’s easier just to take a day, back everything up and re-install Windows from scratch.

Continue reading

Fixing the Orange (or Red) Status Icon in WampServer

As part of my latest project, I decided to try out WampServer, the Windows development environment for developing web applications with Apache web server, MySQL database and PHP scripting (Windows, Apache, MySQL, PHP – WAMP). Packages like WampServer and EasyPHP are simplified ways to create a testing environment on your PC without spending a lot of time downloading, installing and configuring the individual components. The package also includes utilities such as PHPMyAdmin and SQLBuddy for managing your MySQL databases and writing SQL queries. The software is available in 32- and 64-bit versions and the installation is pretty straightforward.

Continue reading