none
Prevent Access Window from launching after a form is maximized and more RRS feed

  • Question

  • Fellow Accessors.

    I have a form that is working fine. We are using the ShowWindow API. When the form is launched we are not showing any access objects to the user. When I minimize, the custom Icon we have also shows in the tool bar. When we maximize the application, it still works fine BUT IF WE HIT THE custome ICON, it brings back he application plus all of the access objects.

    It makes no difference if we use Popup Yes and Modal Yes or popup Yes and Modal No.

    All we want to do is make this work like a real app - no presentation of anything from access.

    Any suggestions would be appreciated.

    Thanks

    MG

    Wednesday, July 27, 2016 3:54 PM

Answers

  • Hi mg30,

    According to your description, I think that Access Com Object has no feature to support to hide the entire Access window, so you use ShowWindow API. I have found some sample code use ShowWindow API to hide the entire Access window, but they are failure after I tested. I am not able to find any good solution to overcome this issue, this issue is Access design issue.

    So I suggest you to submit any feedback to Access UserVoice:

    https://access .uservoice.com/

    Thanks for your understanding.
    • Proposed as answer by David_JunFeng Sunday, August 7, 2016 2:15 PM
    • Marked as answer by David_JunFeng Monday, August 8, 2016 1:39 AM
    Monday, August 1, 2016 6:29 AM
  • Hiding the Access window is getting harder with each new version. I suggest you not try to hide it and just hide the Ribbon and fill in the Application Title property in the database properties. The result will be a main title bar with the Application Title and nothing else.

    Further VBA programming can make sure the Navigation pane and native tabs stay hidden.


    Bill Mosca
    www.thatlldoit.com
    http://tech.groups.yahoo.com/group/MS_Access_Professionals

    • Proposed as answer by David_JunFeng Monday, August 8, 2016 1:40 AM
    • Marked as answer by David_JunFeng Monday, August 8, 2016 1:40 AM
    Monday, August 1, 2016 3:03 PM

All replies

  • You may be fighting the windmills to some extent, but there is a promising technique you could investigate: hiding the Access window behind your Popup form:

    http://stackoverflow.com/questions/12012978/access-2010-hiding-the-access-window

    http://www.tek-tips.com/faqs.cfm?fid=2562


    -Tom. Microsoft Access MVP

    Wednesday, July 27, 2016 4:38 PM
  • Hi mg30,

    According to your description, I have reproduced this issue, this workaround is

    To show the database window, run

        Docmd.SelectObject acTable, , True

    To Hide the database window, run

        Docmd.SelectObject acTable, , True
        Docmd.RunCommand acCmdWindowHide

    In addition you could submit any feedback to Access UserVoice:

    https://access .uservoice.com/

    Thanks for your understanding. 
    Thursday, July 28, 2016 7:22 AM
  • Hi David,

    Thx for the info but we were trying to hide the entire Access window that is in the background.

    We never really got anything to work correctly so we took a different approach.

    MG

    Friday, July 29, 2016 5:19 PM
  • Hi mg30,

    According to your description, I think that Access Com Object has no feature to support to hide the entire Access window, so you use ShowWindow API. I have found some sample code use ShowWindow API to hide the entire Access window, but they are failure after I tested. I am not able to find any good solution to overcome this issue, this issue is Access design issue.

    So I suggest you to submit any feedback to Access UserVoice:

    https://access .uservoice.com/

    Thanks for your understanding.
    • Proposed as answer by David_JunFeng Sunday, August 7, 2016 2:15 PM
    • Marked as answer by David_JunFeng Monday, August 8, 2016 1:39 AM
    Monday, August 1, 2016 6:29 AM
  • Hi David,

    Yes. We agree with your findings as well. thanks for sharing.

    MG

    Monday, August 1, 2016 10:38 AM
  • Hiding the Access window is getting harder with each new version. I suggest you not try to hide it and just hide the Ribbon and fill in the Application Title property in the database properties. The result will be a main title bar with the Application Title and nothing else.

    Further VBA programming can make sure the Navigation pane and native tabs stay hidden.


    Bill Mosca
    www.thatlldoit.com
    http://tech.groups.yahoo.com/group/MS_Access_Professionals

    • Proposed as answer by David_JunFeng Monday, August 8, 2016 1:40 AM
    • Marked as answer by David_JunFeng Monday, August 8, 2016 1:40 AM
    Monday, August 1, 2016 3:03 PM
  • Thanks  Bill

    Monday, August 1, 2016 3:16 PM
  • Thanks  Bill

    You're welcome, MG. Post back if you need some code examples.

    Bill Mosca
    www.thatlldoit.com
    http://tech.groups.yahoo.com/group/MS_Access_Professionals

    Monday, August 1, 2016 7:40 PM