Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Jul 2001
    Location
    NJ, USA
    Posts
    617
    Thanks
    0
    Thanked 0 Times in 0 Posts

    database window (AccessXP)

    Is there a way, with VBA, to make sure that the database window is minimized after/when the splash screen and then switchboard is loaded? I know if you minimize before closing it will open minimized. But I have a habit of not minimizing it.

    Thanks!

    Fay

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

    Re: database window (AccessXP)

    In a "real" Access application, you shouldn't show the database window at all - hide it in Tools/Startup... You can display it with the F11 function key (if you haven't disabled it) or by opening the database with the Shift key down (same remark).

    If you really want to minimize the database window, you can create a macro named AutoExec.
    Its first action is SelectObject, with arguments: Form, <name of a form>, Yes
    The second action is Minimize.

    Alternatively, you can put the equivalent VBA code in the OnLoad event of the splash screen (if you mean an Access form by that) or of the switchboard form:

    DoCmd.SelectObject acForm, "YourFormName", True
    DoCmd.Minimize

  3. #3
    5 Star Lounger
    Join Date
    Jul 2001
    Location
    NJ, USA
    Posts
    617
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: database window (AccessXP)

    Thanks Hans.

    I elected to go the first way, since it seemed the easiest.

    Fay

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: database window (AccessXP)

    Hi Fay,
    Pardon me for butting in, but the best development practices wisdom suggests you always hide the database window if you have more than one user, and do everything with forms. The reason is that users can do lots of damage to a database unless you really tie them down with security. For example, they can delete forms, queries, and even tables if they can see the database window. You situation may not warrant it, but the need may well occur in the future.
    Wendell

  5. #5
    5 Star Lounger
    Join Date
    Jul 2001
    Location
    NJ, USA
    Posts
    617
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: database window (AccessXP)

    Wendall I never think a moderator is butting in. I plan to not display the database window, for the vary reason you mentioned.

    Fay <img src=/S/bananas.gif border=0 alt=bananas width=33 height=35>

Posting Permissions

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