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...
by Jonathan Halder | May 22, 2025 | Blogging, MS Access, MS Access VBA Coding
The SDOpenAI Access plugin uses the OpenAI API to provide “tokens” which means the question or prompts that you use, and return results (again measured in tokens) from the OpenAI system. You are charged by the number of millions of tokens you provide to...
