My latest video shows how to split a database in Microsoft Access to separate the data from the user interface and programming elements. Access can link to data from different file formats including Excel, text files and other Access databases. For multi-user applications, you can have an Access file with just the forms, reports, queries…
Looking for the Ocala I.T. Professionals?
There’s a chance you ended up here on Comeau Software Solutions after looking for the Ocala I.T. Pros site. Here’s why …
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…
Learning a New (Human) Language in 2020
April’s lockdown gave a lot of us some extra time to play with and some people took it as an opportunity to learn new skills or start side projects. At the same time, I found myself working on a new project with people who barely spoke English, if at all. Online translators like Google Trainslate…
Printing Dymo Labels from Microsoft Access
On a recent project, I had to come up with a way to send labels one or two at a time to a Dymo LabelWriter 450 printer from Microsoft Access. Access does a great job of printing sheet-fed and continuous labels but not specifically to the Dymo printer. Normally, I would select a one of…
Online Course – Managing Your Data with Microsoft Access
My new course, Managing Your Data with Microsoft Access is now live! Please take some time to check out the free sample videos. If you sign up early, you’ll get lifetime access to all video content and resources PLUS all future content as I continue to add to the course for the low introductory price.…
Installing MySQL and MariaDB (Videos)
Awhile back, I wrote up some instructions for doing a basic install of MySQL on Windows, including the steps to secure it. Now that I’m working on another MySQL book, I decided to start putting together some videos to go with it and I’ve created a couple on MySQL / MariaDB installation. These videos include…
Designing a Standing Desk Without Spending Lots of Money
I admit it, I spend way too much time sitting. My work is mostly at the computer so that’s where I am for hours every day and that’s not counting the time in front spent watching Hulu and streaming other stuff. Much is being written now about the dangers of prolonged sitting from increased risks…
A Few Thoughts on the Book Writing Process
It Seems Like I’ve Been Here Before … People seem fairly impressed when I mention that I’ve written a couple of books on databases and software. I try not to make a big deal of it, just mentioning it in passing as appropriate, because I actually don’t consider it to be a big deal. I’m…
Recovering a Corrupted Table in Access With VBA
Recently, a client started experiencing errors, seemingly at random, in the database application I managed for them. The errors immediately started mentioning corruption and then these came through … Error 3167 – Record is Deleted Getting everyone out of the system and running a Compact / Repair seemed to help, but then … “The Microsoft…