by Jonathan Halder | Sep 4, 2025 | Blogging, MS Access, MS Access Features, MS Access Queries, MS Access Reports, MS Access VBA Coding
Don’t be afraid to refactor something if it’s getting too complicated. One of my customers often will have new ideas for reports or forms in the Access app that would really help him make his business better and his life easier. Many times these ideas will...
by Jonathan Halder | Sep 3, 2025 | Blogging, MS Access, MS Access Features, MS Access Forms, MS Access Queries, MS Access Tables, MS Access VBA Coding
Ever wonder what a developer running a sole proprietorship does? Here’s a little snapshot of my life this week. This week i’ve been up to a couple of things: I’ve updated a client to provide a button to their navigation to open a particular query....
by Jonathan Halder | Aug 26, 2025 | Blogging, MS Access, MS Access Features, MS Access Queries, MS Access Tables, MS Access VBA Coding
Today I had a request from a customer with a database used for What If scenarios to allow him to do either do updates from the main tables consistently or to boot all other users out of their front ends so that he can do an update when one is required. The system is...
by Jonathan Halder | Aug 19, 2025 | Blogging, MS Access, MS Access Features, MS Access Queries, MS Access VBA Coding
When you need to specify date ranges in Access, remember the following helpful tips: By default, a date includes the time of midnight 00:00:00. So #1/1/2025# is equivalent to the expression #1/1/2025 00:00:00# or #1/1/2025 12:00:00 AM#. When you use Between, it always...
by Jonathan Halder | Aug 18, 2025 | Blogging, MS Access, MS Access Features, MS Access Forms, MS Access VBA Coding
Do you know what happens if you are in an Access text box and press Ctrl-A? You might expect all the text in it to be selected like a text box on a web page or in a Word document. But it doesn’t. If you are in a text box on a form in the normal single form view...
by Jonathan Halder | Aug 11, 2025 | Blogging, MS Access, MS Access Features, MS Access Queries, MS Access Tables
Most of my customers that I build Access apps for have not been Access users. In other words, they tend to know very little about tables or queries or reports, design view, VBA modules and macros. This tends to make my job easier in that I don’t have to be...
