by Jonathan Halder | Jul 25, 2024 | MS Access, MS Access Reports
Maybe you read my last message (Hammers and nails, Access and…? | Access JumpStart) and thought, “Yeah, Access does sound like a good fit for my business needs.” But what would you use it for exactly? If you’ve never used Access or any relational...
by Jonathan Halder | Jul 24, 2024 | MS Access, MS Access Features
It’s important to choose the right tool for the right job. What about Microsoft Access? When is it the best or at least a good tool for the job? Or turning around the question, what are the best jobs to use Access for? The first thing to remember is that Access...
by Jonathan Halder | Jul 23, 2024 | Blogging, MS Access, MS Access Features, MS Access Forms, MS Access VBA Coding
If you are using DoEvents in your VBA code to allow form updates or preventing Windows from labeling your Access app as Unresponsive, make sure you consider the potential ramifications. DoEvents not only chimes in to the OS that it’s awake, but it also allows...
by Jonathan Halder | Jul 19, 2024 | MS Access, MS Access Features, MS Access Forms
I had a customer who was confused as to why a checkbox was being checked or unchecked at seemingly random times. In this particular case, the checkbox label was very wide and butted right up to the button to save the data on the form and close it. In Access, when you...
by Jonathan Halder | Jul 18, 2024 | MS Access, MS Access VBA Coding
I recently needed to calculate the period number of a current date for a client. The current period is not exactly the current week number, it’s a specific week, but it could start on any particular day and end on any particular day. In my case, they specify it...
