Learn MS-Access Tips & Tricks

Access and AI Integration Part 3.
Introduction to JSON and Prompt Parameters.
When working with AI models through APIs—such as those provided by Ollama—data is exchanged using a structured format known as JSON. JSON (JavaScript Object Notation) is a lightweight, text-based format used to represent data as key–value pairs. It is widely adopted because it is both human-readable and easy for machines to parse efficiently. In the context of Microsoft Access and VBA, JSON serves as the communication bridge between your application and the AI engine, transmitting prompts to the model and returning generated responses in a consistent and predictable structure.

Access and AI Integration Part 3 Learn Advanced Microsoft Access Programming Techniques, Tips and Tricks

Modernizing Microsoft Access applications with AI is not about replacing Access—it’s about extending it into a far more intelligent, responsive, and future-ready system. With the right integration approach, Access can evolve from a traditional desktop database into a smart, AI-assisted application platform.
Intelligent Query & SQL Generation
AI models can translate natural language into SQL queries, dramatically reducing the need for manual query design.

AI Integration in Access VBA and SQL Part 2 Learn Advanced Microsoft Access Programming Techniques, Tips and Tricks

Local AI for Microsoft Access SQL and VBA Coding - Part 1.

The idea of using Artificial Intelligence within Microsoft Access may sound complex at first, but recent advancements have made it surprisingly accessible—even on a standard Windows 10/11 PC. With lightweight local AI runtime, such as 'Ollama' and efficient coding-focused models like Qwen2.5-Coder, Access developers can now experiment with AI-assisted SQL and VBA generation directly from within Microsoft Access, without relying on cloud services.

AI Integration in Microsoft Access for VBA Coding Part 1 Learn Advanced Microsoft Access Programming Techniques, Tips and Tricks

Class Module Code for All Data Entry Editing Form.

Streamlining Form Module Code in Standalone Class Module.

Ready-made Class Modules for Data-Entry, Editing, or Viewing.

All the TextBox and ComboBox Controls, on the data handling Form, when enabled with the OnDirty(), and BeforeUpdate() Event Procedures are fully protected from unintentional changes.

Manually writing code for every TextBox and ComboBox on a form can lead to duplication of work and inefficiency. Moreover, modifying event procedure names for each field to match the control name can become tedious and error-prone. Typically, only essential fields undergo this kind of data protection exercise, leaving others vulnerable.

To streamline this process, consider implementing a more automated or systematic approach, such as leveraging reusable code structures, like Standalone Class Modules, that help to centralize and organize Event Procedures more efficiently.

Classes For All Data Entry Editing Forms Learn Advanced Microsoft Access Programming Techniques, Tips and Tricks

Streamlining Code: Data Editing in Zoom-In Control.

Streamlining Form Module Code in Standalone Class Module.

Editing Large Text Box Contents in Zoom-in Control.

This topic was initially Published in August 2007 and titled "Edit Data in Zoom-in Control." In the preceding example, a custom shortcut menu was devised and linked to the form to activate the zoom-in control, enabling the editing of textbox contents with multiple lines of data, akin to the notes field in the Employees Table.

The earlier version of the customized Shortcut Menu for the Employees Form is in the image below for reference.

Streamline Zoom-in Control Data Editing Learn Advanced Microsoft Access Programming Techniques, Tips and Tricks