Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 4th, 2007, 08:41 AM
Friend of Wrox
 
Join Date: Sep 2003
Posts: 451
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to Ben Horne
Default Hidden VBA module....How can I get it to show?

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
 
Old May 4th, 2007, 11:18 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

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
 
Old May 4th, 2007, 11:21 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

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
 
Old May 4th, 2007, 06:43 PM
Friend of Wrox
 
Join Date: Sep 2003
Posts: 451
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to Ben Horne
Default

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




Quote:
quote:Originally posted by 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
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





Similar Threads
Thread Thread Starter Forum Replies Last Post
How can i create VBA code to Insert a Module? stylin99 Excel VBA 1 January 18th, 2008 10:01 PM
vba module larry67 Access VBA 0 March 8th, 2007 05:30 AM
How to show a button have hidden property ??? nobitavn94 ASP.NET 1.0 and 1.1 Basics 2 November 19th, 2006 09:39 AM
how do I show subtotals in an accessreport by vba bogaerts Pro Visual Basic 2005 0 January 30th, 2006 08:32 AM
Show web user control hidden see07 ASP.NET 1.x and 2.0 Application Design 4 February 3rd, 2005 12:09 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.