There's a system for Access similar to Gemini Code Assist for Visual Studio.

[amorosik]

Using Visual Studio, you can appreciate the ability of external extensions like Gemini Code Assist to support developers in creating new code fragments useful for the current project.
For all non-specialized tasks that require specific optimization, the assistant is an excellent tool and allows you to proceed quickly with coding.
Is there anything similar to Gemini Code Assist for Access?
I mean, a system that allows developers to describe the goal they want to achieve directly in the code, and the assistant suggests its own version of a possible solution.

 

[The_Doc_Man]

I do not speak for others, but I am not at this time aware of any package that can be integrated into Access to generate code in the manner you have described. One man's vantage point, limited by having retired and thus only seeing ads and any articles published by AWF members.

If you want to do it in a non-integrated way, take a look at some of Uncle Gizmo's posts, because he actively engages with ChatGPT, which DOES have code generation abilities. If you develop a code snippet in a file, Access can import it to a module. I.e. not integrated, but a two-step process.

UPDATE BY TDM: See also the thread VBA and ChatGPT, discussing an online presentation about AI assistants. You might be able to directly engage the participants in that presentation to get more info.

 

[GPGeorge]

There may be licensed, 3rd party tools. I believe there was a presentation to one of the AUG chapters about such an add-in. Check the YouTube channel,

IIRC, there is a license fee involved. Also, It may or may not be appropriate to what you seek.

We also had a presentation at my AUG chapter on using ChatGPT. The video will be public in a couple of days.

The bottom line, though, is that you can easily incorporate one of the LLM AI's into your coding projects. The key to success seems to be writing good prompts.

I've used Claude extensively over the last few months to help with SQL Server and PowerApps tasks. I think its real benefits come when you are tackling stretch tasks and need to augment your own current mastery of VBA, etc.

 

[Isaac]

I use ChatGPT daily to help me convert from T-SQL to Snowflake. Works great, but I have to tell it what my priorities are and sometimes steer it a bit. And usually be the one responsible to isolate the error more than I'd like

 

[Edgar_]

Gemini can use python, powershell, node and other tools to help you make the access file, add tables, columns, data and other things. It could write the code in external files, for sure. It can't create forms, though, although it can try if you give it the tooling yourself. You could try giving it some context by using the SaveAsText method to see if it can figure out how to build the forms using the blueprints, but that I haven't tried. Try saving its reasoning so that it does not get stuck in loops.

 

[amorosik]

I do not speak for others, but I am not at this time aware of any package that can be integrated into Access to generate code in the manner you have described. One man's vantage point, limited by having retired and thus only seeing ads and any articles published by AWF members.

If you want to do it in a non-integrated way, take a look at some of Uncle Gizmo's posts, because he actively engages with ChatGPT, which DOES have code generation abilities. If you develop a code snippet in a file, Access can import it to a module. I.e. not integrated, but a two-step process.

UPDATE BY TDM: See also the thread VBA and ChatGPT, discussing an online presentation about AI assistants. You might be able to directly engage the participants in that presentation to get more info.

Yes, of course, I already use the various LLMs to propose code fragments and review and improve existing working code.
What I wanted to understand was whether there was something integrated into the intent of the development environment.

 

[amorosik]

I use ChatGPT daily to help me convert from T-SQL to Snowflake. Works great, but I have to tell it what my priorities are and sometimes steer it a bit. And usually be the one responsible to isolate the error more than I'd like

Yes, for me too, the main use is on SQL queries.
From a formal point of view, the queries are created correctly, and this makes the creation of complex queries much quicker.

 

[GPGeorge]

My primary use has been for Stored Procedures in SQL Server.