Change existing references to current version. For example, if MS DAO 3.5 is checked see if you can find MS DAO 3.6 or higher. Is yes, uncheck the old and check the new.
Does anyone else have any idea how to make the editor window hidden or how to open a module without the editor window coming up and staying open after closing the module?
Dean, I tried your code and it doesn't work unless the referenced module is already open. Close Access. Re-open the database, press alt-f11 to bring up the vba editor. I think you'll find that the module your program is writing to is open in the editor. If you try to write to another module...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.