Summary Occasionally, when you’re making a lot of design changes to a Microsoft Access database, Access might start crashing when you’re working with that specific database file or when trying to enter the VBA environment with ALT-F11. This leaves you unable to investigate the issue or make further changes. It can be a sign that there are errors within the project’s…
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. Sometimes, however, you might want to keep all but a few users out of specific…
A Complete Guide to Installing MySQL and PHP with IIS
Update: A video update to this article for Windows Server 2016 / 2019 is available on YouTube. I’m leaving this version up 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…
Portable USB Chargers – Simple, Inexpensive and Useful Accessories
In our new world of rechargeable devices and constant connection, more battery power is never a bad thing. Seeing a battery indicator at 5% and a device begging to be recharged sends many people into a scramble looking for the nearest convenient charging solution. When there’s no outlet available or when you don’t want to leave…
On the Importance of Backups and Storage Decisions
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…
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…
Laptop Bags Don’t Have to be Expensive
After you’ve bought your new laptop computer, taken it out of the box and set it up, your next thought might naturally be “What am I going to carry this in?”. That laptop you just spent hundreds of dollars for is sitting there on your desk and looks naked and unprotected without one of those…
Let’s Teach Kids to Code
Previously published on OcalaITPros.com. “So he was learning many different core principles of design – about how to experiment with new ideas, how to take complex ideas and break them down into simpler parts, how to collaborate with other people on your projects, about how to find and fix bugs when things go wrong, how…
What is Recursive Programming?
When writing programs, it’s often necessary to perform repeating operations on collections of items such as customer orders or invoices. Often, you can just iterate through the collection or count the items to determine how many times to perform the operation. When working with a hierarchy of items such as a directory structure where you have…
Replacing Your Wireless Mouse / Keyboard Receiver
Wireless mice and keyboards are a great way to reduce the tangle of wires on your desktop but what do you do when that tiny USB receiver, the one about the size of your fingernail, goes missing? That’s what I asked myself the other day when I lost the receiver (also called a ‘dongle’) for…