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...
by Jonathan Halder | May 23, 2025 | MS Access, MS Access VBA Coding, Versioning
I have been playing a little bit with the SDOpenAI Access Add In. In particular testing what context is being sent to the API in different situations. When your cursor has nothing selected, the general chat context will send the current line your cursor is on. When...
