Results 1 to 10 of 10
  1. #1
    Join Date
    Aug 2006
    Posts
    559

    Unanswered: Minimize and center?

    Can you minimize the MS Access window, like the part where it says "File", "Edit", "View". And then is there a way you can say to the Access DB, I guess in like a global module / variable, to CENTER ON THE SCREEN all forms that are in the DB?

  2. #2
    Join Date
    May 2005
    Posts
    1,191
    I'm not sure if this'll help you or not, but each form has a property called "Auto Center", and if you set it to Yes, it'll center on your Access window when you open it up.
    Me.Geek = True

  3. #3
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    Regarding the "File", "Edit", "View", you can customize your own menu (changing it from a toolbar to a Menu) and set the Menu Property of the form to the menu you created. But there's probably a better way to go about this.

    Regarding opening a form centered, I've used this type of function in a module...

    Function OpForm(FrmName As String)
    DoCmd.OpenForm FrmName
    DoCmd.MoveSize 5000, 5000
    End Function

    And then I call it...
    Call OpForm("MyFormName")

    if that helps at all. But there's probably better ways to do both.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  4. #4
    Join Date
    Aug 2006
    Posts
    559
    Quote Originally Posted by nckdryr
    I'm not sure if this'll help you or not, but each form has a property called "Auto Center", and if you set it to Yes, it'll center on your Access window when you open it up.

    I'm going to try this, but I figure if I minimize the MS Access window down to like the start menu area, this will also pull the forms down there? I may be wrong, but will give it a whirl.

    If it doesn't work, I'll look at your example, Paul.

    Thanks.


    ***EDITED***

    Nick,

    I did what you said, the "autocenter" property on each form. I figured it was that, which when I did, it works. All of the forms are now centered on the MS Access window.

    Now it's a minimize MS Access window completely so that only forms are displayed. Disable the shift-bypass key but allow with PASSWORD!

    Then, well, besides my report issue, I'm done with this db!
    Last edited by Grafixx01; 06-13-07 at 15:49.

  5. #5
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Quote Originally Posted by Grafixx01
    I'm going to try this, but I figure if I minimize the MS Access window down to like the start menu area
    Not if you set the property of Popup to true.
    George
    Home | Blog

  6. #6
    Join Date
    Aug 2006
    Posts
    559
    Quote Originally Posted by georgev
    Not if you set the property of Popup to true.

    george,

    I don't follow. Can you explain what you mean? The popup property to be 'true'? What's that going to do? Not do?

  7. #7
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Why don't you try it and see?
    Alternatively go read it in the helpfiles - stick your cursor in the property in hit F1
    George
    Home | Blog

  8. #8
    Join Date
    Aug 2006
    Posts
    559
    Quote Originally Posted by georgev
    Why don't you try it and see?
    Alternatively go read it in the helpfiles - stick your cursor in the property in hit F1

    Ok, I found out what that does, setting the "Popup" to 'no' and 'yes'. From what I gather on that property,

    Setting it to "Yes" will allow the window to open but open ontop of the MS Access windows (which I am guessing WILL NOT happen if I minimize the MS Access windows).

    Setting it to "No" does what it does now.

  9. #9
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Quote Originally Posted by Grafixx01
    which I am guessing WILL NOT happen if I minimize the MS Access windows
    Well there's only one way to find out!
    George
    Home | Blog

  10. #10
    Join Date
    Aug 2006
    Posts
    559
    Quote Originally Posted by georgev
    Well there's only one way to find out!

    Oohhh... You're mean! j/k taking a look now.

Posting Permissions

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