locked
Controls placed on a page object bleed through to other underlying pages RRS feed

  • Question

  • Hello:

    I am using Access 365 Pro Plus.  We  have a VBA app that  uses overlapping pages in design mode, code used to show at different times.  In design mode, when I place the TreeView and other controls onto one of the pages, they bleed through to the underlying pages.  Other controls do not do this, just  started happening.  I tried Bring To Front and looked at all properties and cannot find the cause.

    Would appreciate any suggestions.

    thank you


    Regards, Harvey


    Wednesday, October 18, 2017 7:29 PM

Answers

  • Thanks, and I did, but it still bled through.

    Here is the solution.  This is a case of nested tab controls and once I searched on that term, the answer came up immediately.  Below are links to two references that give the same answer, which is to embed the inner tab control onto a form, then to put the form into the outer, containing tab control.

    http://www.utteraccess.com/forum/nesting-tab-controls-t1836960.html

    https://www.experts-exchange.com/questions/24750257/Place-a-Tab-Control-within-another-tab-Control.html

    Thanks all for your suggestions.


    Regards, Harvey

    • Proposed as answer by Chenchen Li Thursday, October 26, 2017 8:49 AM
    • Marked as answer by Harvey Flaisher Thursday, October 26, 2017 3:31 PM
    Friday, October 20, 2017 4:46 PM

All replies

  • Hi Harvey,

    Thanks for visiting our forum.

    Then here we mainly focus on general issues about Office client. Since your query is related to developing questions involving Access, I'll move your thread to the following dedicated MSDN forum for Access:

    https://social.msdn.microsoft.com/Forums/en-US/home?forum=accessdev

    The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

    Best regards,
    Yuki Sun


    Please remember to mark the replies as answers if they helped.

    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.


    Thursday, October 19, 2017 2:53 AM
  • Hi Harvey,

    Are you referring to the pages of a Tab Control? If so, make sure you select the page you want to add the control before adding it.

    Hope it helps...

    Thursday, October 19, 2017 1:36 PM
  • thanks Yuki - I had looked for development when entering, but could not find it.
    Thursday, October 19, 2017 2:03 PM
  • No, pages of a MultiPage control.  I will probably have to convert that to a tab control if I cant find a solution.

    I think this is a bug in Office365.  

    Thank you

    Thursday, October 19, 2017 2:04 PM
  • Oh, sorry. I only have 2013, so I am not familiar with MultiPage controls. Can you post a screenshot?
    Thursday, October 19, 2017 3:31 PM
  • There is really nothing to show, but we have had these in since the very first versions of MS Access - not tied to Office365.  Documented here....

    https://msdn.microsoft.com/en-us/vba/language-reference-vba/articles/multipage-control?f=255&MSPPError=-2147217396

    Thursday, October 19, 2017 5:18 PM
  • Do these controls that "bleed through" have transparent backgrounds? If so, you might try changing to Normal background and make sure the background color is the same as your form background color.
    Thursday, October 19, 2017 5:48 PM
  • There is really nothing to show, but we have had these in since the very first versions of MS Access - not tied to Office365.  Documented here....

    https://msdn.microsoft.com/en-us/vba/language-reference-vba/articles/multipage-control?f=255&MSPPError=-2147217396


    Is there nothing to show because this is only done using VBA? For example, is there no button to add a MultiPage control from the Design Tab on the Ribbon? I'm sorry but I am really not familiar with it. When I went to the link you provided and clicked on the MultiPage Object link at the bottom of the page, it took me to Outlook objects. Is a MultiPage object or control only in other Office apps or also in Access? Thanks for the clarification/education.
    Thursday, October 19, 2017 9:06 PM
  • I was able to look at what a multipage control is, and it appears to only be applicable to an Outlook object. Apparently, under Office 365 you can use VBA code with Outlook Form objects. Is that what you are talking about? An Outlook e-mail application? Or are you asking about placing an Outlook object on an ACCESS form?
    Thursday, October 19, 2017 9:41 PM

  • Regards, Harvey

    Friday, October 20, 2017 2:44 PM

  • Regards, Harvey

    Friday, October 20, 2017 2:44 PM
  • Hello DBGuy:

    the bottom scnshot shows pgCoding.  It looks the way I want it to.  The top one is pgSearch, an underlying page made visible and invisible as desired in code.  Note how the tab control on the bottom left of pgCoding has bled through into pgSearch.

    thanks


    Regards, Harvey

    Friday, October 20, 2017 2:47 PM
  • Hi Lawrence:

    this is an Access form in MS Access.  Please see scnshots I uploaded above. 

    Thank you


    Regards, Harvey

    Friday, October 20, 2017 2:49 PM
  • Note how the tab control on the bottom left of pgCoding has bled through into pgSearch.

    Hi Harvey,

    How are these overlapping pages defined? Are they 2 different subforms with the same dimensions that switch their visibility? Are the controls that are bleeding on a separate subform?

    What happens if you change the SourceObject of the one subform instead of having two overlapping subforms?

    Imb.

    Friday, October 20, 2017 3:11 PM
  • Hello DBGuy:

    the bottom scnshot shows pgCoding.  It looks the way I want it to.  The top one is pgSearch, an underlying page made visible and invisible as desired in code.  Note how the tab control on the bottom left of pgCoding has bled through into pgSearch.

    thanks


    Regards, Harvey

    Hi Harvey,

    Thanks for posting the screenshots. Can you please tell me the steps to create a MultiPage control, so I can do some testing for you? Thanks.

    Friday, October 20, 2017 3:12 PM
  • I have just discovered that the "page" objects discussed above appear to be part of a tab control.  I just created a new tab control and found that Page objects appear on each tab.  So the main control I am speak of is a TabControl, not a MultiPage control.

    Regards, Harvey

    Friday, October 20, 2017 3:34 PM
  • I have just discovered that the "page" objects discussed above appear to be part of a tab control.  I just created a new tab control and found that Page objects appear on each tab.  So the main control I am speak of is a TabControl, not a MultiPage control.

    Regards, Harvey

    Hi Harvey,

    Okay, if we're actually talking about a Tab Control, then the suggestion I made earlier applies. Make sure you have the Page selected before dropping any control on top of the page. Otherwise, you will be associating the new control to the form rather than a tab page, which will result in the control showing on all pages on the Tab Control.

    Hope it makes sense...

    Friday, October 20, 2017 3:41 PM
  • Thanks, and I did, but it still bled through.

    Here is the solution.  This is a case of nested tab controls and once I searched on that term, the answer came up immediately.  Below are links to two references that give the same answer, which is to embed the inner tab control onto a form, then to put the form into the outer, containing tab control.

    http://www.utteraccess.com/forum/nesting-tab-controls-t1836960.html

    https://www.experts-exchange.com/questions/24750257/Place-a-Tab-Control-within-another-tab-Control.html

    Thanks all for your suggestions.


    Regards, Harvey

    • Proposed as answer by Chenchen Li Thursday, October 26, 2017 8:49 AM
    • Marked as answer by Harvey Flaisher Thursday, October 26, 2017 3:31 PM
    Friday, October 20, 2017 4:46 PM
  • Hi Harvey,

    Glad to hear you got it sorted out. Good luck with your project.

    Friday, October 20, 2017 4:56 PM
  • Thanks

    Regards, Harvey

    Friday, October 20, 2017 7:55 PM
  • Hello,

    Thanks for sharing. I suggest you mark your solution as answer to close this thread.

    Regards,

    Celeste


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Thursday, October 26, 2017 8:50 AM