Results 1 to 6 of 6
  1. #1
    Lounger
    Join Date
    Dec 2000
    Location
    Ohio, USA
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Displaying Database Window (97)

    Hello,
    I have turned off "Display Database Window" under Startup. I would like to in VBA turn the window back on but all the help talks about is at startup.
    Suggestions?

  2. #2
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Displaying Database Window (97)

    <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Cat=&Board=acc&Number=61509&page=& view=&sb=&o=&vc=1#Post61509>I think this post might provide the answer.</A>

  3. #3
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Emerald Beach, New South Wales, Australia
    Posts
    126
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Displaying Database Window (97)

    <pre> strDocName = "tblName" 'any table will do.
    ' Give focus to Database window; select table (first
    ' table in list is ideal).

    DoCmd.SelectObject acTable, strDocName, True
    </pre>


  4. #4
    Lounger
    Join Date
    Dec 2000
    Location
    Ohio, USA
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Displaying Database Window (97)

    Thank you for the post, however I am not trying to open the database window at startup. I am trying to let a user with permission open the database window.

  5. #5
    Lounger
    Join Date
    Dec 2000
    Location
    Ohio, USA
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Displaying Database Window (97)

    Thank you for your post. After moving a close command so my form closed not my database window this worked well.
    <img src=/S/fanfare.gif border=0 alt=fanfare width=31 height=23>

  6. #6
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Displaying Database Window (97)

    Yes, I see. Please accept my apologies. I didn

Posting Permissions

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