A.D.Tejpal
adtp at touchtelindia.net
Thu Sep 18 03:32:46 CDT 2003
Rocky,
In the said state, the subform does not necessarily have a visible window. If you check for all open windows by Alt + Tab, you might not find the subform anywhere. However, it acts as if open in design mode even though you feel certain (in your words - "know for a fact" ) that it is not open.
As a test, if you try to open the main form in normal view, you get the message "You can't open a subform when it is also open ii Design view"
The phenomenon occurs when you disturb the subform's code module in some way. Merely opening the VBA window and the fact that a particular module happens to be in view, does not cause any problem.
Coming to the point raised towards the end of your message, the following scenarios could be considered -
A - Main form has been opened (in any view) before opening the VBA Editor - No problem.
B - Main form has Not been opened before opening the VBA Editor -
(a) If the code module for the main form is disturbed before touching that for the subform, no problem.
(b) If the code module for subform is disturbed before touching that for the main form, you get into the problem of blank rectangle. It does not get rectified merely by tinkering with (or putting in view) the code module for main form. You then have to go to database window, select the subform, open it in design view and close it again.
It might also be desirable to keep the VBA Editor window always closed when not actively needed..
Regards,
A.D.Tejpal
--------------
----- Original Message -----
From: Rocky Smolin - Beach Access Software
To: Access Developers discussion and problem solving
Sent: Wednesday, September 17, 2003 23:26
Subject: Re: [AccessD] SubForm Disappears In Design View
AHA! I know more than one person who will be interested in this.
Now I know for a fact when I get the blank rectangle that the sub-form is not open. However, I generally keep the code window open all the time. If the code window is open to the subform's module, is that what's causing this? So would opening a different code window (say, the main form's) cause the sub-form to re-appear in the main form?
Rocky
----- Original Message -----
From: A.D.Tejpal
To: Access Developers discussion and problem solving
Sent: Wednesday, September 17, 2003 10:29 AM
Subject: Re: [AccessD] SubForm Disappears In Design View
Rocky,
Blank rectangle in place of subform (on opening the main form in design view), is indicative of the subform being already open in design view, even though you might not have consciously opened the same.
Whenever the code module for any form or report is handled in the VBA editor, the corresponding object (form / subform / report / subreport) gets simultaneously opened in design view.
Remedy - Close the main form, open the subform in design view (no need to keep searching for it), close it - and then open the main form in design view. Everything should be OK.
Prevention - Prior to undertaking any editing of associated code modules of the main or subform, open the main form in design view. This will forestall the problem mentioned by you.
Regards,
A.D.Tejpal
--------------
----- Original Message -----
From: Rocky Smolin - Beach Access Software
To: Access Developers discussion and problem solving
Sent: Wednesday, September 17, 2003 21:27
Subject: Re: [AccessD] SubForm Disappears In Design View
I always (try to remember to) turn off the Autocorrect feature. It causes
some problem that I can't remember anymore, only that I want that sucker off
all the time.
So if I turn it on maybe the disappearing sub-forms will stop disappearing
(but I'll get that other problem back)?
Regards,
Rocky
----- Original Message -----
From: "Michael R Mattys" <michael.mattys at adelphia.net>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Wednesday, September 17, 2003 8:37 AM
Subject: Re: [AccessD] SubForm Disappears In Design View
> Rocky,
>
> After looking over TSI_Subforminator, I have
> come to the conclusion that it has to do with the
> Name AutoCorrect feature.
>
> Apparently, it needs to open subforms live in order
> to track the names. TSI_Subforminator appears to
> update the name maps for the Access 2000 Name
> AutoCorrect feature before opening a subform in
> design view.
>
> Michael R. Mattys
> Try MattysMapLib for MapPoint at
> www.mattysconsulting.com
>
>
>
> ----- Original Message -----
> From: "Rocky Smolin - Beach Access Software" <bchacc at san.rr.com>
> To: "Access Developers discussion and problem solving"
> <accessd at databaseadvisors.com>
> Sent: Wednesday, September 17, 2003 9:41 AM
> Subject: Re: [AccessD] SubForm Disappears In Design View
>
>
> > Michael:
> >
> > Well that works around the problem when it occurs. Thanks. I'm still
> > curious about why that happens. There doesn't seem to be any pattern to
> it.
> >
> > Best,
> >
> > Rocky
> >
> > ----- Original Message -----
> > From: "Michael R Mattys" <michael.mattys at adelphia.net>
> > To: "Access Developers discussion and problem solving"
> > <accessd at databaseadvisors.com>
> > Sent: Tuesday, September 16, 2003 9:45 PM
> > Subject: Re: [AccessD] SubForm Disappears In Design View
> >
> >
> > > Hello Rocky,
> > >
> > > Michael Kaplan made something for this
> > > Look here:
> > > http://www.trigeminal.com/lang/1033/utility.asp?ItemID=5
> > >
> > > Michael R. Mattys
> > > Try MattysMapLib for MapPoint at
> > > www.mattysconsulting.com
> > >
> > >
> > >
> > > ----- Original Message -----
> > > From: "Rocky Smolin - Beach Access Software" <bchacc at san.rr.com>
> > > To: <AccessD at databaseadvisors.com>
> > > Sent: Wednesday, September 17, 2003 12:29 AM
> > > Subject: [AccessD] SubForm Disappears In Design View
> > >
> > >
> > > Dear List:
> > >
> > > In A2K sometimes when I open a main form with a subform in design
view,
> my
> > > sub-form disappears to be replaced by a big white box. If I want to
> work
> > on
> > > it, I have to close the main form and open the subform in design view
> from
> > > the database container. Then, some random amount of time later, the
> > subform
> > > reappears on the main form in design view. It's a real PITA.
> > >
> > > Has anyone seen this behavior and found a solution to it?
> > >
> > > MTIA,
> > >
> > > is
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030918/9da60636/attachment-0001.html>