Terri Jarus
jarus at amerinet-gpo.com
Wed Sep 17 14:42:37 CDT 2003
I have this same problem with users in production, using a tabbed form with subforms. Some users that are on the system have no problem - everything works fine. Some users (and it's the same ones) get a blank white rectangle where a subform should appear - for every tab that has a subform.
We think it's a network issue regarding folder rights - although we're not sure as yet. I have all rights to the folder that houses the BE - the FE is on my local drive and a copy of the FE is on each user's local drive. My network guy seems to think that because the users do not have Delete rights (they have all others) that this might be the problem. We don't want them to be able to accidentally delete the BE - rightfully so.
I am going to try turning off the AutoCorrect feature to see if that makes a difference. I'm running out of options and ideas and my users are getting frustrated.
I'll let you know if we ever get this problem resolved. It's a little different in that we have the problem in production, but not in design....
Terri Jarus
Director, Contract Support Services
jarus at amerinet-gpo.com
314-542-1902
>>> cfoust at infostatsystems.com 09/17/03 01:02PM >>>
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
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
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
---------------------------------------------------------------------------
This email and any files transmitted with it are confidential and
intended solely for the use of the individuals or entities to whom they
are addressed. If you have received this email in error please return
it to the sender, and erase any copies thereof.
Copyright 2003 AmeriNet 1nc.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030917/9c416f34/attachment-0001.html>