Results 1 to 7 of 7
  1. #1
    ssashraf is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Dec 2012
    Posts
    9

    Unable to open DB window on a Button click

    Hi, I am having a Database which opens the DB window on a Button Click working fine in Access 2003, but the same database is unable to get the DB window on a Button click in Access 2007/2010. For time being Iam using SetProperties "AllowBypassKey" with a password after user login to access DBwindow with ShiftKey for selected users which is working.



    Please help me get the DB window on button click

    Regards,

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Not sure what you mean by 'DBwindow' - the navigation pane?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    ssashraf is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Dec 2012
    Posts
    9
    Yes, I mean to say Navigation Pane.

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Review http://www.pcreview.co.uk/forums/sho...-t3089845.html

    F11 key will toggle the navigation pane.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    ssashraf is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Dec 2012
    Posts
    9
    I Used below code on the button
    DoCmd.SelectObject acTable, , True

    It is showing the navigation pane but I cannot right clik on that to go to the design.

    Acctually I wanted some users to use the navigation pane to create some queries or modify as per their requirement.


    Please help

  6. #6
    ssashraf is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Dec 2012
    Posts
    9
    attached is the code I am using in Access 2003 to get the Navigation Pane & the Menu Bar.

    I am calling "ShowDBWindow" function on a button click which is working in 2003 but not in 2007
    Attached Files Attached Files

  7. #7
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    You have multiple users and they all open the same copy of the database and can edit that one copy? This is not advisable.

    What do you mean by 'cannot right clik on that to go to the design'? If the navigation pane is open, click on any object in the pane and open it in design view.

    I tested those commands in my db and they work. Doesn't even need API calls.
    DoCmd.SelectObject acTable, , True
    DoCmd.RunCommand acCmdWindowHide
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 06-18-2012, 07:14 AM
  2. Report does NOT open on BUTTON CLICK
    By taimysho0 in forum Programming
    Replies: 3
    Last Post: 01-04-2012, 02:38 PM
  3. Click button to open a new image
    By tia in forum Forms
    Replies: 2
    Last Post: 10-10-2011, 11:03 AM
  4. Unable to open db if not the first user
    By shabbott in forum Security
    Replies: 3
    Last Post: 02-25-2011, 08:24 PM
  5. Replies: 1
    Last Post: 03-03-2010, 07:29 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums