In MSAccess I am writing a module that will update a vba module by replacing the lines with lines stored in an Oracle table. This enables remote users to get updates without a network share.
The problem is to create a Module object
(set mdl = Modules(modulename)) I have to open the module first (DoCmd.OpenModule modulename). This opens the vba editor which stays open after the module has been modified and closed.
Is there a way that my users never have to see the vba editor?
The problem is to create a Module object
(set mdl = Modules(modulename)) I have to open the module first (DoCmd.OpenModule modulename). This opens the vba editor which stays open after the module has been modified and closed.
Is there a way that my users never have to see the vba editor?