Navigation Pane and Ribbons

[kimosavi]

Hi. Thanks to all that have contribute to helping on my project. Almost done!

I have some issues with the navigation pane and ribbons

I when to Access Options and unchecked the nav. pane and ribbons.

1. when the form loads 3 ribbon tabs exists (home, add-ins,acrobat).
how can i remove those ribbons as well??

2. when the form loads the nav. pane is hidden, but when i run the code:

docmd.transferdatabase xxxx

the nav. pane reapear!
how to permanently hide this nav pane???

thanks in advance!

 

[kimosavi]

I found the solutions searching different sites....

1. when the form loads 3 ribbon tabs exists (home, add-ins,acrobat).
how can i remove those ribbons as well??

http://msdn.microsoft.com/en-us/library/bb187398.aspx

look at the steps in Scenario: Marketing Projects Database

will show how to replace the home tab with your own.
add-ins and acrobat must remove them manually, thru Access or Registry (in the case of Acrobat).

remember to Uncheck the Allow Full Menu Option as well.

2. when the form loads the nav. pane is hidden, but when i run the code:

docmd.transferdatabase xxxx

the nav. pane reapear!
how to permanently hide this nav pane???

docmd.transferdatabase acLink or acImport will force the Nav Pane to show (since it create a new table object)

to overcome this i had to create my own function to create the links

[/COLOR]
[COLOR=blue][/COLOR] 
[COLOR=blue]Sub LinkDatabase(Filename As String, TblName As String)
    Dim DB As Database
    Dim newTDF, TDF As TableDef
    Set DB = OpenDatabase(Filename)
    Set TDF = DB.TableDefs(TblName) 
    Set newTDF = CurrentDb.CreateTableDef(TDF.Name)
    newTDF.SourceTableName = TblName
    newTDF.Connect = ";DATABASE=" & Filename
    CurrentDb.TableDefs.Append newTDF
    DB.Close
    Set DB = Nothing[/COLOR]
[COLOR=blue]End Sub
[/COLOR]
[COLOR=blue]

this will prevent the Nav. Pane from showing. Also remember to turn off Access Special Keys in the Access Options, since you can also show the Nav. Pane by hitting F11.

Hope this helps!!

Kimo

 

[boblarson]

Thanks for posting back with your success and with the solutions! That is great and hopefully will save someone else some trouble in the future.