I wrote a routine to programmatically replace the code modules in a "destination" MS Access VBA Project with the latest version of those modules stored in a separate "master" Access project. If the code module exists in both projects, it is deleted from the "destination" and re-added using the copy from the "master".
The routine works perfectly except for one thing: When a module is deleted and then re-added (or, for that matter, when a NEW module is added) programmatically, Access also prompts the user to save EACH new module. So far, I have not been able to figure out a way to disable that prompt.
In my program, I use "Application.Quit adSaveAll" and I have also tried adding "Applicaion.SetOption "Confirm Record Changes, False". There must be a way to disable that save prompt.
Any help would be greatly appreciated.
Denis
The routine works perfectly except for one thing: When a module is deleted and then re-added (or, for that matter, when a NEW module is added) programmatically, Access also prompts the user to save EACH new module. So far, I have not been able to figure out a way to disable that prompt.
In my program, I use "Application.Quit adSaveAll" and I have also tried adding "Applicaion.SetOption "Confirm Record Changes, False". There must be a way to disable that save prompt.
Any help would be greatly appreciated.
Denis