Results 1 to 10 of 10
  1. #1
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926

    Unanswered: Restore Down on Opening MSAccess

    I would like to open my MSAccess application in a "Restore Down" state (not maximized or minimized). I can't seem to find the code anywhere which allows me to do this. Any help would be greatly appreciated.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  2. #2
    Join Date
    Mar 2007
    Posts
    277
    Have you tried DoCmd.Restore?
    RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP, ac07, ac10 - WinXP Pro, Win7 Pro
    Please reply to this forum so all may learn.

  3. #3
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    Yes. I tried the docmd.restore command but this does not Restore Down the entire application, only the form. I want to Restore Down the entire MSAccess application (so that the entire MSAccess application always opens up centered in a Restore Down state - i.e. as if you opened the application and clicked the Restore Down button so it is centered and smaller). I know I can open the MSAccess application and click the Restore Down and it retains this but I have other MSAccess applications which open up maximized which in turn then opens this specific application maximized. Again, this is the entire MSAccess application (not just the form). I'm guessing that I need to use some command such as me.application..... or tap into the menubar somehow.
    Last edited by pkstormy; 04-13-07 at 13:15.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  4. #4
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    After searching and searching, I still can't find anything to issue a Restore Down command when the MSAccess application opens. This would be of great help if anyone knows where I can find information on this. Basically all I want to do is have code which automatically clicks the button between the _ (minimize application) and X (maximize application) in the upper right corner of the upper menu bar of the application (not on the form).
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  5. #5
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    What about Application.RunCommand acCmdAppMinimize?

  6. #6
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    This work?

    DoCmd.RunCommand acCmdAppRestore
    Paul

  7. #7
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    Just reread your post, you probably want Application.RunCommand acCmdAppRestore.

  8. #8
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    Yes - Awesome. Thank you VERY much!
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  9. #9
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    crap, spent ten minutes searching was gonna post the same thing,
    only to find dckunkle beat me to it
    Inspiration Through Fermentation

  10. #10
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    And Paul
    George
    Home | Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •