<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

Access 2010

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.