Basic Filtering with form text boxes

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...

CDO email using a queue and emailing from one server

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...

SDOpenAI Access Add In – controlling context through selecting text.

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...

What are the options for OpenAI access? (as of May 2025)

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...

Access VBA AI experiments – Full version of SDOpenAI Access Plugin installed

by Jonathan Halder | May 21, 2025 | Blogging, MS Access, MS Access Features, MS Access VBA Coding

So far, I have the SDOpenAI Access Plugin reinstalled and purchased and entered in the license number. Good deal. I was able to create a function header with a descriptive line of Public Function GetDateXDaysPriorToToday(days As Single) As Date with a single for days...

Preparing to use AI for programming

by Jonathan Halder | May 20, 2025 | Blogging, MS Access, MS Access VBA Coding, TDD, Versioning

So, I am beginning again to move into a place where I will attempt to use some AI tools. What will this do for me? Here are some of the things I’m hoping it will help with: Allowing me to delegate simple coding tasks like functions and subroutines. Get...