Results 1 to 5 of 5
  1. #1
    RLehrbass is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2015
    Posts
    102

    I can not get my Database options to not display the navigation bar!

    ok,
    I have set my options to protect my Db.
    I have unchecked "display navigation bar", "allow full menus", "allow default shortcut menus" and "allow built-in tool bars". After restarting , everything else is missing but the nav bar just wont go away. I have retried many times but, no go. I have even tried to change user levels on my login but it does not have any effect either.



    Any thoughts?

    Also, On my split Db FE, i created a new table 'USysRibbon' to set a default ribbon without the "options" function, but I can not see the new table on the tables nav bar. I remade the table, but it says it already exists. Why can't I see it. All the tables in my FE have the blue arrow next to them to show the redirect. I am new to split Db's

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,771
    You mean navigation pane?

    It should not show if you have disabled. Something (some code somewhere) must be expanding the pane. Unless function keys are disabled, F11 will do that.

    System tables are hidden by default. Set navigation pane option to show system objects.
    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
    RLehrbass is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2015
    Posts
    102
    Moderator,
    Ok, I have Identified that it is the opening of the Switchboard that is causing the Navigation Pane to be visible. I commented out the open form "switchboard" in the Login screen VBA and the Navigation pane is no longer visible. I have looked at the vba code for the switchboard, but it is very complicated and I really don't know what I am looking for.
    What would such a code look like? that would make the Navigation Pane visible?

  4. #4
    RLehrbass is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2015
    Posts
    102
    This is the code (BOLDED) that is causing the NavPane to reopen. What does this code actually do and do I need it? If I comment it and the next line out, the switchboard seems to still work fine.
    Private Sub Form_Open(Cancel As Integer)
    ' Minimize the database window and initialize the form.

    On Error GoTo Form_Open_Err

    ' Minimize the database window.
    DoCmd.SelectObject acForm, "Switchboard", True
    DoCmd.Minimize

    ' Move to the switchboard page that is marked as the default.
    Me.Filter = "[ItemNumber] = 0 AND [Argument] = 'Default' "
    Me.FilterOn = True

    Form_Open_Exit:
    Exit Sub

    Form_Open_Err:
    MsgBox Err.Description
    Resume Form_Open_Exit

    End Sub

  5. #5
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,771
    I have never used SelectObject method. This is causing object in the pane to be selected, just as if you had clicked on it manually and in doing so programmatically, it simultaneously expands the pane because can't select something in the pane without it expanded and if you want to select something in the pane surely you want to see it - at least that is the logic.

    If I want to open a form I use OpenForm method.
    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. URL (website) display options in SharePoint
    By SethG in forum SharePoint
    Replies: 1
    Last Post: 09-29-2014, 04:47 PM
  2. Split Form Display Options
    By tmill29 in forum Forms
    Replies: 2
    Last Post: 05-15-2014, 12:56 PM
  3. Subreport Display Multiple Options
    By tmcrouse in forum Forms
    Replies: 1
    Last Post: 05-02-2014, 11:49 AM
  4. Access 2007-Display image options
    By lliefveld in forum Access
    Replies: 4
    Last Post: 01-16-2013, 04:12 PM
  5. Replies: 0
    Last Post: 07-26-2010, 01:45 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