<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1226" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=468190118-17092003><FONT face="Comic Sans MS" color=#0000ff
size=2>Actually, that's what happens in A97 and earlier. In A2k and later,
you get a warning message if you try to open a subform
that's</FONT></SPAN></DIV>
<DIV><SPAN class=468190118-17092003><FONT face="Comic Sans MS" color=#0000ff
size=2>already open in either design or runtime view.</FONT></SPAN></DIV>
<DIV><SPAN class=468190118-17092003><FONT face="Comic Sans MS" color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=468190118-17092003><FONT face="Comic Sans MS" color=#0000ff
size=2>Charlotte Foust</FONT></SPAN></DIV>
<DIV><SPAN class=468190118-17092003></SPAN> </DIV>
<DIV></DIV>
<DIV><FONT face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Rocky
Smolin - Beach Access Software [mailto:bchacc@san.rr.com] <BR><B>Sent:</B>
Wednesday, September 17, 2003 9:57 AM<BR><B>To:</B> Access Developers discussion
and problem solving<BR><B>Subject:</B> Re: [AccessD] SubForm Disappears In
Design View<BR><BR></DIV></FONT>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV><FONT face=Arial size=2>AHA! I know more than one person who will
be interested in this. </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>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?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Rocky</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=adtp@touchtelindia.net
href="mailto:adtp@touchtelindia.net">A.D.Tejpal</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">Access Developers discussion and
problem solving</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, September 17, 2003
10:29 AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [AccessD] SubForm
Disappears In Design View</DIV>
<DIV><BR></DIV>
<DIV><STRONG>Rocky,</STRONG></DIV>
<DIV> </DIV>
<DIV> 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. </DIV>
<DIV> </DIV>
<DIV> 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.</DIV>
<DIV> </DIV>
<DIV> 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.</DIV>
<DIV> </DIV>
<DIV> 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.</DIV>
<DIV> </DIV>
<DIV>Regards,</DIV>
<DIV><STRONG>A.D.Tejpal</STRONG></DIV>
<DIV><STRONG>--------------</STRONG></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=bchacc@san.rr.com href="mailto:bchacc@san.rr.com">Rocky Smolin -
Beach Access Software</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">Access Developers discussion
and problem solving</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, September 17, 2003
21:27</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [AccessD] SubForm
Disappears In Design View</DIV>
<DIV><BR></DIV>I always (try to remember to) turn off the Autocorrect
feature. It causes<BR>some problem that I can't remember anymore,
only that I want that sucker off<BR>all the time.<BR><BR>So if I turn it
on maybe the disappearing sub-forms will stop disappearing<BR>(but I'll
get that other problem back)?<BR><BR>Regards,<BR><BR>Rocky<BR><BR>-----
Original Message ----- <BR>From: "Michael R Mattys" <<A
href="mailto:michael.mattys@adelphia.net">michael.mattys@adelphia.net</A>><BR>To:
"Access Developers discussion and problem solving"<BR><<A
href="mailto:accessd@databaseadvisors.com">accessd@databaseadvisors.com</A>><BR>Sent:
Wednesday, September 17, 2003 8:37 AM<BR>Subject: Re: [AccessD] SubForm
Disappears In Design View<BR><BR><BR>> Rocky,<BR>><BR>> After
looking over TSI_Subforminator, I have<BR>> come to the conclusion that
it has to do with the<BR>> Name AutoCorrect feature.<BR>><BR>>
Apparently, it needs to open subforms live in order<BR>> to track the
names. TSI_Subforminator appears to<BR>> update the name maps for the
Access 2000 Name<BR>> AutoCorrect feature before opening a subform
in<BR>> design view.<BR>><BR>> Michael R. Mattys<BR>> Try
MattysMapLib for MapPoint at<BR>> <A
href="http://www.mattysconsulting.com">www.mattysconsulting.com</A><BR>><BR>><BR>><BR>>
----- Original Message -----<BR>> From: "Rocky Smolin - Beach Access
Software" <<A
href="mailto:bchacc@san.rr.com">bchacc@san.rr.com</A>><BR>> To:
"Access Developers discussion and problem solving"<BR>> <<A
href="mailto:accessd@databaseadvisors.com">accessd@databaseadvisors.com</A>><BR>>
Sent: Wednesday, September 17, 2003 9:41 AM<BR>> Subject: Re: [AccessD]
SubForm Disappears In Design View<BR>><BR>><BR>> >
Michael:<BR>> ><BR>> > Well that works around the problem when
it occurs. Thanks. I'm still<BR>> > curious about why
that happens. There doesn't seem to be any pattern to<BR>>
it.<BR>> ><BR>> > Best,<BR>> ><BR>> >
Rocky<BR>> ><BR>> > ----- Original Message -----<BR>> >
From: "Michael R Mattys" <<A
href="mailto:michael.mattys@adelphia.net">michael.mattys@adelphia.net</A>><BR>>
> To: "Access Developers discussion and problem solving"<BR>> >
<<A
href="mailto:accessd@databaseadvisors.com">accessd@databaseadvisors.com</A>><BR>>
> Sent: Tuesday, September 16, 2003 9:45 PM<BR>> > Subject: Re:
[AccessD] SubForm Disappears In Design View<BR>> ><BR>>
><BR>> > > Hello Rocky,<BR>> > ><BR>> > >
Michael Kaplan made something for this<BR>> > > Look
here:<BR>> > > <A
href="http://www.trigeminal.com/lang/1033/utility.asp?ItemID=5">http://www.trigeminal.com/lang/1033/utility.asp?ItemID=5</A><BR>>
> ><BR>> > > Michael R. Mattys<BR>> > > Try
MattysMapLib for MapPoint at<BR>> > > <A
href="http://www.mattysconsulting.com">www.mattysconsulting.com</A><BR>>
> ><BR>> > ><BR>> > ><BR>> > > -----
Original Message -----<BR>> > > From: "Rocky Smolin - Beach
Access Software" <<A
href="mailto:bchacc@san.rr.com">bchacc@san.rr.com</A>><BR>> >
> To: <<A
href="mailto:AccessD@databaseadvisors.com">AccessD@databaseadvisors.com</A>><BR>>
> > Sent: Wednesday, September 17, 2003 12:29 AM<BR>> > >
Subject: [AccessD] SubForm Disappears In Design View<BR>> >
><BR>> > ><BR>> > > Dear List:<BR>> >
><BR>> > > In A2K sometimes when I open a main form with a
subform in design<BR>view,<BR>> my<BR>> > > sub-form
disappears to be replaced by a big white box. If I want to<BR>>
work<BR>> > on<BR>> > > it, I have to close the main form
and open the subform in design view<BR>> from<BR>> > > the
database container. Then, some random amount of time later,
the<BR>> > subform<BR>> > > reappears on the main form in
design view. It's a real PITA.<BR>> > ><BR>> > > Has
anyone seen this behavior and found a solution to it?<BR>> >
><BR>> > > MTIA,<BR>> > ><BR>> > >
is<BR></BLOCKQUOTE>
<P>
<HR>
<P></P>_______________________________________________<BR>AccessD mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>