Alright,


So I've been working on a database in Access 2000 for a job placement agency in Madison (where I work), and so far, everything's going fine. However, I am having issues with getting a code module called Jobs to show up, even though I have Access set up to show hidden objects (The module is one of those hidden objects, because I don't want anyone editing the code, and thus breaking the functionality that I have added).


Is there any way to get that module to show up again, short of overwriting it with a new one?





Ben Horne
-------------------------
I don't want to sound like I haven't made any mistakes. I'm confident I have.

Most likely using FireFox and concocting my next Macromedia Flash project
Snibworks Forums Moderator

Welcome to the New Age

__________________
Ben Horne
-------------------------
I don\'t want to sound like I haven\'t made any mistakes. I\'m confident I have.

Most likely using FireFox and concocting my next Macromedia Flash project
Snibworks Forums Moderator

Welcome to the New Age

I would try the following, depending on how you locked it:

Select Tools > Options

Then click the View tab. In the upper right, put a check box in the "Hidden objects" check box.

That should work.

To make things easier, once you do this, right click the module, select Properties, and uncheck the Hidden check box.

Did any of that help?

mmcdonal

Now that I reread your post, it seems like you may already have done this. Are you sure the module is actually there? What function does it do that you can test with code? I have not heard of that happining before.

Did you set it up to be visible on one computer, and then tried to view it on another computer? The view hidden objects works by the computer, not by the file. I always leave mine to show hidden objects, knowing that my users do not have this selected.

HTH

mmcdonal

Yes,

I'm fairly sure that it's there, even though it's not showing up in either the Database Window, or in the Visual Basic for Applications project list.


I coded one public function so far, which is called CapAll, and I believe that in order to get any functionality out of code in forms, you have to have the procedure in one main module (CapAll, for example)


The State field in my Employer Information form uses this CapAll function.


I dunno, if nothing else pans out, I might just try over-writing the module with a new one, and this time, do NOT hide any main module until I'm certain I can do so




Ben Horne
-------------------------
I don't want to sound like I haven't made any mistakes. I'm confident I have.

Most likely using FireFox and concocting my next Macromedia Flash project
Snibworks Forums Moderator

Welcome to the New Age