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...
by Jonathan Halder | Jul 1, 2025 | Blogging, MS Access, MS Access Features, TDD, Versioning
Yesterday, I had found a method for CoPilot to see an entire database. In order to do this, all the objects of the database need to be exported to text files. This is an undocumented and unsupported feature of Access, but it has been there for a long time and is what...
by Jonathan Halder | May 28, 2025 | Blogging, MS Access, MS Access Features, MS Access Tables, MS Access VBA Coding
I have a couple clients now who had emails they wanted to either send out on a scheduled basis, like every Thursday, and/or when certain events occurred, like importing a certain type of file with certain types of part numbers, or a po is updated and causes a project...
by Jonathan Halder | May 21, 2025 | Blogging, MS Access, MS Access Features, MS Access VBA Coding
So far, I have the SDOpenAI Access Plugin reinstalled and purchased and entered in the license number. Good deal. I was able to create a function header with a descriptive line of Public Function GetDateXDaysPriorToToday(days As Single) As Date with a single for days...
