Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Apr 2002
    Location
    St. Paul, Minnesota, USA
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Database Window, Hidden when Database is opened (MS Access 2000)

    Hello All!

    I've got a database, developed in MS Access, that is set to open up to a form (and hide the database window). I'd like to create a button on the form that when clicked would open the database window. Any ideas? So far I've found out the F11 on the keyboard will open the database window, but can I program this using vb on the button to act as though the user pressed the F11 key and open the database window? Also, I found a reference to StartupShowDBWindow Property but I don't know how to use it. The database would already be open anyway before the user would press the button to open the database window so I am not sure if this property would even work.

    Any one got any ideas?

    Thanks in advance,

    Amanda

  2. #2
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Database Window, Hidden when Database is opened (MS Access 2000)

    You can use SendKeys for this:
    <pre> SendKeys "{F11}", True</pre>

    Note: I use this for my own purposes when designing/testing application where database window is normally hidden. This "option" is NOT available to the end-users of application, and is disabled in Startup options. I would not recommend making database window visible to users under normal circumstances.

    HTH

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

    Re: Database Window, Hidden when Database is opened (MS Access 2000)

    I second Mark's comment - you don't want to have the average user able to see and work in the database container window.
    Why? Well, they can delete objects that the database needs, such as tables, queries, forms and reports (unless you activate security). In addition, they can edit records in tables that cause referential integrity problems, and you have no idea who did it or when. We like to use security and hide the database window, and we then capture information about who changed what when using hidden fields on the form they are required to use. Forms also make it much easier for users to figure out what data to edit and where to edit it. Just the opinions of one who has been there and been burned.
    Wendell

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Database Window, Hidden when Database is opened (MS Access 2000)

    Here's what I use behind a transparent button on my switchboard forms:

    DoCmd.SelectObject acForm, Me.Name, True

    What this tells Access is to select the current form object in the database window.
    Charlotte

  5. #5
    Lounger
    Join Date
    Apr 2002
    Location
    St. Paul, Minnesota, USA
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Database Window, Hidden when Database is opened (MS Access 2000)

    Thanks so much guys! I understand the the approach of not letting them see the Database Window - trust me, I've been burned before too. But, when you are a small pawn like me there isn't much I can say to make them change their minds (other then laugh in the faces when they delete a table...)

    Thanks again,

    Amanda

Posting Permissions

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