by Jonathan Halder | Jan 17, 2025 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding
In other languages, when you build a class, there are things called constructors which can take parameters when you instantiate the class as an object in order to initiate it. This is very handy, as you can abbreviate what you need to do into a much smaller number of...
by Jonathan Halder | Jan 16, 2025 | Blogging, MS Access, MS Access VBA Coding, Versioning
We all re-use code in one form or another. Perhaps it begins by copying and pasting routines into a text file. Perhaps you’ve used people’s online repositories of code that they place online, or you share your code in forum posts and search there for code...
by Jonathan Halder | Jan 15, 2025 | Blogging, MS Access
I’ve been musing on my work and planning out my 2025 1st quarter projects. I am a big proponent of planning and tracking changes. Here are some of the tools I use: For capturing ideas: Pocket Sized Field notebook and pen – At the simplest level for times...
by Jonathan Halder | Jan 14, 2025 | Blogging, MS Access, MS Access Features, MS Access VBA Coding
One strategy I have used to run automated processes with Access is to use Command Line switches. So to start up Access you use the Access program “MsAccess.exe”, usually with the full path to it, then use the database you are opening as an argument, and...
by Jonathan Halder | Jan 13, 2025 | Blogging, MS Access, MS Access VBA Coding
I seem to have had a number of problems lately with a particular user who is running into issues trying to open an Access application multiple times. When doing so, the second instance will shutdown, but before doing so will display a box saying that Access already...
by Jonathan Halder | Jan 10, 2025 | Blogging, MS Access, MS Access Forms, MS Access Queries, MS Access Reports, MS Access VBA Coding
Another gotcha in Access is when you use a function of any kind as a query field or as a bound field on a form or report. This can also be done in Conditional Formatting fields in forms and reports. Let’s say you bind a continuous form field to the builtin...
