This seems to be rather a silly question but how do I remove a form from the VBA Project Explorer window? When I first setup the database, the form in question contained VBA code so it was included in the Project Explorer window. As the database has evolved (well, mostly as I have evolved), the coding changed such that the form is still in use but no longer has any code.
Since there are a number of forms, subforms, and reports, I would prefer to only see the ones with VBA code in my Project Explorer. I have been playing with this for quite a while and have not reached any solution beyond recreating the form from scratch but without the code this time. Any ideas?
8 7697
You can close the project explorer window by setting focus to the applicable window, and clicking the X in the upper right corner. To re-open hit CTRL-R Keys.
NeoPa 32,556
Expert Mod 16PB
In the properties of your form (Design View) set "Has Module" to No.
This should produce the effect you're after.
PS. It will also lose ALL code you may still have in that object (the form) so don't expect to be able to return from this change later.
Exactly what I was looking for, NeoPa. Thanks so much!
NeoPa 32,556
Expert Mod 16PB
No worries Rach - Pleased to help :)
Welcome to BYTES!
As the database has evolved (well, mostly as I have evolved), the coding changed such that the form is still in use but no longer has any code.
I'm fascinated with the idea of evolving to the point where my forms don't require any code!
Welcome to Bytes, RachH!
Linq ;0)> NeoPa 32,556
Expert Mod 16PB
Possibly there are references now to controls on the form, whereas before the controls had their info passed using code in the AfterUpdate events or something similar.
It was something like that. The forms in question were subforms and, using the master/child interaction, I figured out a more efficient way to accomplish what the code had originally accomplished. It was very much a matter of my understanding of Access having evolved. And believe me, the amount of code I added to other forms more than makes up for the few forms that were stripped of their code!
NeoPa 32,556
Expert Mod 16PB
LOL
Looking back over the stuff in my databases, I can see where I wrote stuff before I understood certain things.
I try to bring older stuff up-to-date when I can, but there's so much there now that's getting quite impractical - even for just my main database.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Richard Lewis Haggard |
last post by:
I'm new to C# deployment project way of doing things and have run into a
problem with a deployment project that has me stumped. I've put together a
deployment of a project which works just fine for...
|
by: George |
last post by:
I unintentionally clicked on "Exclude from project" while I was on my .aspx
file. I went in and added it back into the project, but I could no longer
bring up my Web form that I designed.. There...
|
by: Lee Newson |
last post by:
Hi,
I have just written my first application using VB.NET. The app works fine
when i am running it within .NET for debugging purposes, however when i try
to run the app from the .exe file that...
|
by: Zorpiedoman |
last post by:
Horay!
I have just put the finishing touches on a new User Control...
The" Jelly Button"
I created a setup program which runs fine. I see the .dll nicely in the GAC.
How come it does not...
|
by: Hugh |
last post by:
Hi there,
An existing solution is used to create a new solution. It
is easy to change the names of individual forms and
modules. However, how to change the name of project
folder? Thanks in...
|
by: garyusenet |
last post by:
Hi,
I will outline what i'm trying to do here, and would really like to
here your suggestions of how I can do it please.
I have some code which finds the open internet explorer windows. I...
|
by: garyusenet |
last post by:
Dear Professionals,
I have recently been using the wonderful krypton toolkit and am trying
to use them in my small hobby application. I include this bit of info
as an aside really because i'm...
|
by: Jwe |
last post by:
Hi,
I've written a program which has both a command line interface
and Windows form interface, however it isn't quite working
correctly.
When run from command line with no arguments it should...
|
by: Lloyd Sheen |
last post by:
This is VS 2008 acting like VS 2002. I open a form and it is marked as
changed.
Why would that happen?
LS
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |