Access JumpStart 2.0 | Blog

A Rapid Development Framework for Microsoft Access

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 you have text selected, that text will be sent as the context for a general chat. That means you can select the text of an entire function or an entire module in the VBE and it will be sent as the context when you ask a question in the general chat.
  • I have been informed by the creator of this plugin Alex Denz, that it can send more information and all the related functions of the current function. It is unclear to me so far when it sends more context or auto-collects and sends more context.

While it may be somewhat unclear to me right now, that’s just because I have just started investigating it.

It does seem nice that I can import a class using the add-in to then write code to interact with the API in a variety of ways, so if I want to build a function to pass more context… say I want to read all the files in my source folder of my versioning system and want to pass all that to the API as context, I should be able to do that.

In addition, I can create custom functions and put them on the command ribbon. I’m looking forward to continuing to explore this. There is a lot to learn about how this works! The SDOpenAI Add-In for Microsoft is very flexible.

Sign up For a Daily Email Adventure in Microsoft Access

Every business day (typically M-F), I'll send you an email with information about my ongoing journey as an advanced Access application developer. It will be loaded with my tips and musings.

    We won't send you spam. Unsubscribe at any time.