Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / April 2007

Tip: Looking for answers? Try searching our database.

Object won't go to background

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
G-Man - 22 Mar 2007 00:20 GMT
I have a form that has three subforms that overlay each other depending on
what is requested on the form.

So, there's the main form with it's buttons and such
Then, there's subform1, 2,and three that lay directly over an area of the
main form.

This has worked fine. The other day, I had to add a button to the main form
which is in an area which overlayed by the subforms.

Now, when I run the form, I see that button show up initially on all layers.

The easiest way I can explain it is with something like a comparision to MS
Publisher.  In publisher I tell objects to go all the way to the back or
bring forward. Well a button that belongs on the back layer (main form) shows
itself on each of the subform layers as well.

Make sense?  What more can I offer you?  Thanks
strive4peace - 22 Mar 2007 04:08 GMT
I know what you mean, it shows initally then goes away...layering
doesn't work with subform objects, they are always on top but other
things underneath them display briefly...

Why not just make the visible property of the button false?

Warm Regards,
Crystal
 *
     (:  have an awesome day  :)
  *
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
  *

> I have a form that has three subforms that overlay each other depending on
> what is requested on the form.
[quoted text clipped - 14 lines]
>
> Make sense?  What more can I offer you?  Thanks
G-Man - 22 Mar 2007 05:50 GMT
That's the kicker.  There are 10 other "menu buttons" on the parent form and
I just added a new one next to them.  All the other's don't show briefly,
only this new one.

The database is one I inherited.  I don;t like the three sub forms layered
on top of other objects on the parent form . . . but it's OK. I simply drag
the sub forms out of the way, make my addition to the parent form, then drag
them back. When I do, the only button to briefly show is the one I added.  
All others on the parent form remain hidden during the initial open.  Why?

Thanks for your response. I appreciate any added assistance I can get. It's
real anoying

> I have a form that has three subforms that overlay each other depending on
> what is requested on the form.
[quoted text clipped - 14 lines]
>
> Make sense?  What more can I offer you?  Thanks
John W. Vinson - 22 Mar 2007 06:54 GMT
>The database is one I inherited.  I don;t like the three sub forms layered
>on top of other objects on the parent form . . . but it's OK. I simply drag
>the sub forms out of the way, make my addition to the parent form, then drag
>them back. When I do, the only button to briefly show is the one I added.  
>All others on the parent form remain hidden during the initial open.  Why?

Have you tried a Tab Control?

You can CUT each subform, select a page of the tab control, and paste it onto
the page. They'll still share the same screen real estate but each will be on
its own tab page.

Just dragging the subform onto the page will NOT work - it will be layered in
front of the tab control, not attached to it.

            John W. Vinson [MVP]
G-Man - 05 Apr 2007 01:20 GMT
John and Strive4peace,

Thanks for your responses. I think I will take the subforms and maybe
institute the tab Control option.  I have not used this much but I like the
idea of not stacking sub-forms on top of each other.

> >The database is one I inherited.  I don;t like the three sub forms layered
> >on top of other objects on the parent form . . . but it's OK. I simply drag
[quoted text clipped - 12 lines]
>
>              John W. Vinson [MVP]
strive4peace - 05 Apr 2007 02:42 GMT
switch subform SourceObject vs tab control
---

Hi G-Man,

another thing I do quite often is switch the SourceObject of a subform
control -- in fact, I rarely use the tab control anymore.  If you want a
generic method for this, I will be happy to share ... it uses VBA code
and a table to keep track of what gets swapped.

By having less subforms, a main form will load faster too :)

Warm Regards,
Crystal
 *
     (:  have an awesome day  :)
  *
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
  *

> John and Strive4peace,
>
[quoted text clipped - 17 lines]
>>
>>              John W. Vinson [MVP]
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.