Results 1 to 7 of 7
  1. #1
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Windows in VB editor (Access 2000 and up)

    Is it possible to keep Access from opening a window for each VB object when the VB editor is opened? I have some databases for which only a few windows initially open, while other always open all of them. For the life of me I can't figure out how or why they are different.

    Even more confusing is that I've got Access2000 on 2 computers, and I thought they were same versions (both say Access2000 SP-3). But on one, the Windows dropdown on main menubar offers a "Close all Windows" option, while the other computer doesn't. However, even this option doesn't keep the windows closed when the Editor is re-opened.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Windows in VB editor (Access 2000 and up)

    As far as I have been able to understand how the VBE handles this, the current window configuration is stored when a module (of any type) is saved.

    So: you have 2 windows open in the VBE. You modify something, and save the changes, and close the database. Next time you open the database, the two windows will be open in the VBE. Now, you close the two windows, and close the database. When you reopen it, the two module windows will be open too! This is because you didn't save a module after closing the windows.

    Do you have an add-in that adds the 'Close All Windows' menu item? I don't think it is a standard VBE menu item.

  3. #3
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Windows in VB editor (Access 2000 and up)

    In 2003, I find I have a Close All Windows command in the Windows menu. I think it might be put there by MZ Tools.


    My experience is that the Editor returns to the state you left it. So after finding that the number of code windows was just growing and growing, I now make a point of closing each code window as I finish it.
    Regards
    John



  4. #4
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Windows in VB editor (Access 2000 and up)

    I didn't think about it, but it probably is the MZ-Tools Add-in that put in the "Close all windows".
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  5. #5
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Windows in VB editor (Access 2000 and up)

    Yes, I think you are right, it must be the MZ Tools. I just didn't connect.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  6. #6
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Windows in VB editor (Access 2000 and up)

    The MZ Tools toolbar has a Close All Windows button on it,and it uses the same icon as the one next to the Close All Windows command in the menu. (I didn't notice this until after my previous post.)
    Regards
    John



  7. #7
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Windows in VB editor (Access 2000 and up)

    Explicity closing windows (rather than using the Close All Windows) does seem to help. Although there does seem to be some inconsistencies. Seems to me there should be some logic behind it; but I suppose this is just another Microsoft "feature".
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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