[AccessD] SubForm Disappears In Design View

Charlotte Foust cfoust at infostatsystems.com
Wed Sep 17 13:02:36 CDT 2003


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
already open in either design or runtime view.
 
Charlotte Foust
 
-----Original Message-----
From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com] 
Sent: Wednesday, September 17, 2003 9:57 AM
To: Access Developers discussion and problem solving
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 <mailto:adtp at touchtelindia.net>  
		To: Access Developers discussion and problem solving
<mailto:accessd at databaseadvisors.com>  
		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
<mailto:bchacc at san.rr.com>  
			To: Access Developers discussion and problem
solving <mailto:accessd at databaseadvisors.com>  
			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
			

		
  _____  


		

		_______________________________________________
		AccessD mailing list
		AccessD at databaseadvisors.com
		http://databaseadvisors.com/mailman/listinfo/accessd
		Website: http://www.databaseadvisors.com
		

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030917/a1ee62e0/attachment-0001.html>


More information about the AccessD mailing list