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 27, 2025 | Blogging, MS Access
When I began my business doing consulting, the freedom was great. I could do anything I wanted whenever I wanted. No one was there to look over my shoulder to tell me what to do. I knew I had to deliver things, but it seemed that was always a job for “Future...