Disappearing Modules... need urgent help !

[edtab]

I am encountering a very unusual problem. I have an application with VBA coding contained in modules. I can see all the codings when I open it up in my machine. However, when I install the software at the client's location, the modules are "blank" (no code showing) when I open them up for editing. Yet, the program seems to work fine!

This is making my project very difficult to edit at the client's location which may be required from time to time.

If anyone can shed some light, it would be very much appreciated.


edtab

 

[Travis]

Are you distributing and MDE file to your client?

If you are, then this is why you can't see the code but everything works. The MDE process converts the code to the machine language (compiled). An MDE by this nature runs faster since it does not have to interpret the code.

 

[edtab]

Unfortunately not. I know you can't change the code of an mde. I'm talking about a simple mdb.

Can Access be installed in such a way that modules can be hidden? If you can, I am not aware of it.


edtab

 

[boblarson]

Actually, it would appear (or not appear as the case may be) that you can hide modules. I just tried it and it worked.

 

[edtab]

Hi Bob,

Would you want to share how you hid your modules? This is quite interesting !

edtab

 

[boblarson]

In the Tools/Options there are checkboxes as to what can be displayed. As long as the Hidden Objects box is not checked (default is unchecked), you can right click on a module and select the checkbox that says HIDDEN.

 

[edtab]

Hello Bob,

Thanks for sharing your knowledge with the forum. Just goes to show the more you learn, the more you realize you don't know enough.

This is another way of protecting your code without converting to an mde.


edtab