Anybody know how to run code that will supply the password for the VB editor (not the Database) so that I can make updates to modules through code?
If I try to run code that changes other lines of code, it won't let me until the password is given. I will eventually have other users run these routines from the front end, so I don't want them going into the VB editor to supply the password before they run the operation.
I'm looking for something like a:
DoCmd.OpenModule "TESTModule"
with one more argument where I can open/update protected code by supplying the password. I hope this exists. The only other option is to remove the password, which I really don't want to do.
Any help is appreciated.
-Nish
If I try to run code that changes other lines of code, it won't let me until the password is given. I will eventually have other users run these routines from the front end, so I don't want them going into the VB editor to supply the password before they run the operation.
I'm looking for something like a:
DoCmd.OpenModule "TESTModule"
with one more argument where I can open/update protected code by supplying the password. I hope this exists. The only other option is to remove the password, which I really don't want to do.
Any help is appreciated.
-Nish