Cannot hide navigation bar in Access 2007


G

Guest

According to the documentation, if you go into Access Options, Current
Database and uncheck Display Navigation Pane this should hide it. It does
not. The navigation pane shows up the same regardless of how this box is
checked.

What is the problem?
 
Ad

Advertisements

G

Guest

Did you close out of Access and then reopen after setting the option?

Just as an FYI - It SHOULD work initially, however if you (or a user) hits
F11 then it will display and then when you hit F11 again it will not
completely go away.
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
____________________________________
Access 2000, 2003, 2007, SQL Server 2000, Crystal Reports 10/XI, VB6
WinXP, Vista
 
G

Guest

Yes, I closed the database and reopened it. I even closed Access and
reopened it. It makes no difference.
 
A

Allen Browne

What happens when the database opens?
Do you have an AutoExec macro or a form that opens?
Is there anything there that could be causing the NavPane to be displayed?

For example, if you have a switchboard form that contains instructions to
minimize the DatabaseWindow, it will cause the NavPane to become visible.
 
G

Guest

What is happening is any function that runs the Transferdatabase command
(used extensively in the app for detaching/reattaching tables and
importing/exporting data) makes the Navigation Pain reappear. A pain indeed.
Is there some way to lock the thing down so once you disable it, it cannot
be redisplayed by F11 or any runtime function?
 
A

Allen Browne

You can disable F11 by turning off Special keys under the Access options.

But that won't affect functions.
 
Ad

Advertisements

G

Guest

I have since found that the docmd.transferdatabase command is a known issue
with the navigation pane. How can the pane be disabled in code?
 
A

Allen Browne

Hopefully the issue will be addressed when Office 2007 SP1 is released.

I've heard others speak of this, Steve, but I have not been able to
reproduce the problem. I don't get the NavPane appearcing when I try
something like this:

DoCmd.TransferDatabase acExport, "Microsoft Access", _
"C:\MyFolder\MyDB.mdb", acTable, "Table1", "Table1", False
 
G

Guest

I think the problem is with acLink. Try:
docmd.TransferDatabase acLink

It is good to know that it doesn't happen with exporting.
 
A

Allen Browne

Okay: we're talking linking.

If it really matters (may not, if SP1 fixes it), a workaround might be to
use the TableDefs collection to perform the linking.
 
G

Guest

Where it will matter is when linking to something other than an Access table.
Transferdatabase allows different table types, like ODBC, but TableDefs is
only for Jet.
 
Ad

Advertisements

A

Allen Browne

Can't you include the database type as part of the Connect property of ODBC
tables?

Values in the string are semi-colon delimited.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top