by Jonathan Halder | Jun 3, 2025 | Blogging, MS Access, MS Access VBA Coding
Today I was considering how best to setup automated upgrades for a customer for when I deploy a new version of their Access suite. I say suite because it is together about 9 Access programs that all get installed using an install file that I create using SSE Install...
by Jonathan Halder | Jun 2, 2025 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding
What did I do today? I have a complex order form I built according to customer specs. They have several different scenarios and ways in which they can open an order in the form and I did not build the form so that it is capable of opening multiple orders at once. In...
by Jonathan Halder | May 30, 2025 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding
I started using the SDOpenAI plugin to write a class that could take multiple form control input values and create a string for a filter output for a form. It did a simple and respectable job in accomplishing my task, but as I started implementing it, I started...
by Jonathan Halder | May 29, 2025 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding
There’s tons of good articles out there on this. Just a couple of notes, I had a customer asking me about filtering a subform in a datasheet view. They were using Ctrl-F to bring up the Access find box which they were lamenting was not set to partial content by...
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...
