This project is truly spectacular.
A perfect example to bring to the attention of those who persist in viewing the Microsoft Access development system as a simple form and report builder.
Congratulations, great work.
What you mean exactly "..which has a copy of my whole project as text files.." ???
You have exported all the objects contained in an Access project using tools like vcs-access ?
And can you have them analyze a project composed of hundreds of files?
Copied the contents of modVariabiliGlobali to a text file
Deleted the modVariabiliGlobali module
Compacted the project
Created a new module, named modVariabiliGlobali2
Pasted the contents of the text file into the new module
Now debug/compile correctly
Access probably somehow 'marked' the module...
Good question
Yes, on other modules, for example modFtpServer module, the intellisense show all vars expected
Wait a moment, if i write modVariabiliGlobali.gbDebug the variable is correctly recognized, if i write gbDebug si not recognized
As if gbDebug was a public member of a class module...
I exported manually by going over the module and right-clicking, then selecting Export to Text File
The result is shown below
At first glance, it doesn't seem like anything special.
Attribute VB_Name = "modVariabiliGlobali"
Option Compare Database
Option Explicit
'Public sFiles() As String...
"First time" indicates the first time I try compile after the project has been imported from text files
"..Do you import into a newly created blank Access file .." Yes
Thanks for the suggestion
But I just tried importing all the objects from a text files, and the first time I try to compile it, it gives me the problem of undefined variables
I absolutely have to continue using the project as before, before exporting/importing, otherwise it won't work properly...
This is what I did.
All global variables are defined within the standard modVariabiliGLobali module and are in the form "Public gbDebug As Boolean"
But if I try to use gbDebug in other forms/modules/report/class, the code doesn't seem to recognize them.
(All modules have the Option Explicit line)
I have a project created with Access 2013, 32-bit
I normally use this procedure to export the entire project to a text file and archive it (VCS_ImportExport.bas / ExportAllSource)
After the last export, I also followed the reverse procedure, and then tried recreating the project from the newly...
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.
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.
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...
https://www.tomshw.it/hardware/piattaforma-ai-cancella-database-aziendale-per-errore-2025-07-21
...Its automated system deleted an entire company database containing thousands of records, then attempted to cover up the incident with what many called "dishonest behavior." ...
It's learning to...