I hide the navigation pane when starting my application but after this code it appears again? Strange?
At the end of this procedure I rewrite this code (hide navigation pane) and it disappears again.
How can I solve this problem.
Code:
CurrentDb.Execute "SELECT * INTO [;DATABASE=" & txtDatabaseFilePadNaam & ";].tblOVSGToetsresultaten " & _
"FROM [Excel 12.0;HDR=Yes;DATABASE=" & txtBestandPuntenBestaat & ";].[Pagina1$];", dbFailOnError
DoCmd.TransferDatabase acLink, "Microsoft Access", txtDatabaseFilePadNaam, acTable, "tblOVSGToetsresultaten", "tblOVSGToetsresultaten", False
At the end of this procedure I rewrite this code (hide navigation pane) and it disappears again.
Code:
'hide navigation pane again
'select navigation pane
DoCmd.NavigateTo "acNavigationCategoryObjectType"
'hide navigation pane
DoCmd.RunCommand acCmdWindowHide
How can I solve this problem.