Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Brisbane, Australia
    Thanked 0 Times in 0 Posts

    Display Database Window Programatically (XP-2003/na)

    Is it possible to display the database window via VBA (users don't normally see the window because of startup settings) with a designated user accessing it for maintenance purposes?

    That user will have a password to display it.

    Or are there other suggestions to give the 'admin' maintenance access.

    Thanks, Leigh

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Display Database Window Programatically (XP-2003/na)

    If you allow the use of Access Special Keys in Tools | Startup..., anyone can unhide the database window by pressing F11.
    Anyone can bypass the startup options by keeping Shift down while opening the database, unless you have used code to disable Shift as bypass key. (Search for allowbypasskey in this forum for more info.)

    You can display the database window programmatically by selecting a database object (table, query, form, ...) and specifying that it be displayed in the database window:

    DoCmd.SelectObject acTable, "tblTest", True

Posting Permissions

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