Results 1 to 7 of 7
  1. #1
    Star Lounger
    Join Date
    May 2006
    Posts
    51
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Hiding Database window not working (Access 97)

    I have removed the checkmark that enables the Database Window from displaying, but the window still shows up.

    I have a custom Switchboard menu called in Startup, that appears fine. But the Database Window shows as a minimized window in lower left corner.
    I have enabled/disabled the various menu options, etc. But no matter what I do, that Database Window is always visible and accessible.

    This is a shared front end to a shared back end. There is no one else on the network, but I have tried fixing this by opening in exclusive mode also. Any other changes I make on the Startup options are retained. But it always works like the checkbox is set for this window. Is there a file somewhere where I can force the setting to hide this window?

    This also seems to be unique to this particular database. The window toggles properly in other 97 files on this machine.

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Hiding Database window not working (Access 97)

    Hi There

    Just as an experiment. Create a macro and call it autoexec. Create one action = RunCommand with the Argument =WindowHide. Save it and the close the database and see what happens ( Do not have any forms opening on Start Up , let's just see if the window DB window can hide.
    Jerry

  3. #3
    Star Lounger
    Join Date
    May 2006
    Posts
    51
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hiding Database window not working (Access 97)

    Thanks Jezza.

    That did hide the window. I killed my Switchboard, made the one line macro "autoexec", saved and closed.
    Opened the database, window was hidden. I was able to make it visible from Main Menu, Windows/Unhide.

    Next step?

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

    Re: Hiding Database window not working (Access 97)

    There is code in the On Open event of the Switchboard form in Access 97 that minimizes the database window, so even if you clear the check box in Tools | Startup, the database window will still be displayed. You can avoid this by deleting or commenting out the line with DoCmd.SelectObject in the On Open event of the Switchboard form.

  5. #5
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Hiding Database window not working (Access 97)

    That is good, I was just doing a quick error checking process to ensure that the DB was not corrupt. Now keep the autoexec active and now put the the switchboard Display/Form in the Tools | Startup and try again. Obviously make a back up of your database.

    The autoexec will take precedence, then Start Up will take over and display your switchboard...... <img src=/S/sneaky.gif border=0 alt=sneaky width=15 height=15>
    Jerry

  6. #6
    Star Lounger
    Join Date
    May 2006
    Posts
    51
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hiding Database window not working (Access 97)

    PERFECT!

    Commenting out the lines in Switchboard loading was the solution.

    That was too easy, and I cannot believe I did not think to look at the Switchboard.
    Tell me that this is one of those "well known, undocumented" startup issues. I have been unable to find this referenced anywhere.

    Thanks to Hans and Jerry for your quick and correct analysis and solution.

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

    Re: Hiding Database window not working (Access 97)

    It's just one of those things I remember from the time I used Access 97. In Access 2002, that line is not present any more in the code generated by the Switchboard Manager (although the comment associated with it is still there...)

Posting Permissions

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