<div>
Hello,<br>there is no way to avoid it, but you can deal with the navigation pane...<br><br>DoCmd.NavigateTo ("acNavigationCategoryObjectType")<br>DoCmd.Minimize<br><br>to minimize the pane...<br><br>DoCmd.NavigateTo ("acNavigationCategoryObjectType") <br>DoCmd.RunCommand (acCmdWindowHide)<br><br>to hide the pane.
</div>


<div>
Thanks Bembi<br><br>DoCmd.NavigateTo ("acNavigationCategoryObjectType")<br>DoCmd.RunCommand (acCmdWindowHide)<br><br>the DoCmd.Minimize, &nbsp; does work<br><br>but the, &nbsp;DoCmd.RunCommand (acCmdWindowHide),<br>doesn't work it closes the current form but doesn't hide the pane.<br>can you tell what's the problem?<br>thanks<br><br>
</div>


<div>
Bembi,<br>i see already the DoCmd.NavigateTo ("acNavigationCategoryObjectType") <br>only works to minimize but not hide the pane.<br>what can we do?<br><br>
</div>


frimy

<div>
<div class="content wysiwyg-content fr-view">
Hello All,<br><br>How do I hide the Navigation Pane in Acc 2010?<br><br>when ever i use to import Excel file into my database using,<br>DoCmd.TransferSpreadsheet acLink, acSpreadsheetTypeExcel8, "TBLname", wImportName, True <br>the navigation pane opens.<br><br>Thanks
</div>
</div>



Hello All,
How do I hide the Navigation Pane in Acc 2010?
when ever i use to import Excel file into my database using,
DoCmd.TransferSpreadsheet acLink, acSpreadsheetTypeExcel8, "TBLname", wImportName, True
the navigation pane opens.
Thanks


Hello,
there is no way to avoid it, but you can deal with the navigation pane...
DoCmd.NavigateTo (&quot;acNavigationCategoryObjectType&quot;)
DoCmd.Minimize
to minimize the pane...
DoCmd.NavigateTo (&quot;acNavigationCategoryObjectType&quot;)
DoCmd.RunCommand (acCmdWindowHide)
to hide the pane.


Thanks Bembi
DoCmd.NavigateTo (&quot;acNavigationCategoryObjectType&quot;)
DoCmd.RunCommand (acCmdWindowHide)
the DoCmd.Minimize,   does work
but the,  DoCmd.RunCommand (acCmdWindowHide),
doesn&#39;t work it closes the current form but doesn&#39;t hide the pane.
can you tell what&#39;s the problem?
thanks


Bembi,
i see already the DoCmd.NavigateTo (&quot;acNavigationCategoryObjectType&quot;)
only works to minimize but not hide the pane.
what can we do?

Access 2010


Hello All,
How do I hide the Navigation Pane in Acc 2010?
when ever i use to import Excel file into my database using,
DoCmd.TransferSpreadsheet acLink, acSpreadsheetTypeExcel8, &quot;TBLname&quot;, wImportName, True
the navigation pane opens.
Thanks

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.