UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Database Window In Access 2010, Access 2010    
 
   
foxtrojan
post Oct 31 2019, 02:43 AM
Post#1



Posts: 1,189
Joined: 8-May 06
From: Singapore


Access 2003 have a command button to open up the Database Window, where I access my Tables, queries, etc etc. How do I get my Database Window in Access 2010?
Go to the top of the page
 
isladogs
post Oct 31 2019, 03:57 AM
Post#2


UtterAccess VIP
Posts: 2,243
Joined: 4-June 18
From: Somerset, UK


Its called the navigation pane. If its hidden, click F11 to show it. click F11 again to toggle its size.
You can also manage it from File … Access Options … Current Database
I can also provide code for this if you want it.,

--------------------
Colin (Mendip Data Systems)
Website, email
Go to the top of the page
 
DanielPineault
post Oct 31 2019, 04:38 AM
Post#3


UtterAccess VIP
Posts: 7,259
Joined: 30-June 11



That all changed as of Office 2007. Now everything is in the Navigation Pain Pane.

You may find the following links useful

--------------------
Daniel Pineault (2010-2019 Microsoft MVP, UA VIP, EE Distinguished Expert 2018)
Professional Help: https://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: https://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc


All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...(you are responsible for your choices and actions)
Go to the top of the page
 
foxtrojan
post Oct 31 2019, 05:29 AM
Post#4



Posts: 1,189
Joined: 8-May 06
From: Singapore


Thanks Collin, yes, yes, it will be great if you have codes for them. Really appreciate it.
Go to the top of the page
 
foxtrojan
post Oct 31 2019, 05:38 AM
Post#5



Posts: 1,189
Joined: 8-May 06
From: Singapore


Hi Daniel Pineault, Thank you so much for your feedback. Those documentations really helps to master my new 2010, after using 2003 for 15 years. Thanks again.
Go to the top of the page
 
isladogs
post Oct 31 2019, 06:42 AM
Post#6


UtterAccess VIP
Posts: 2,243
Joined: 4-June 18
From: Somerset, UK


Place the code below in a standard module

CODE
Option Compare Database
Option Explicit

Public Function ShowNavigationPane()

On Error GoTo ErrHandler

    DoCmd.SelectObject acForm, , True
    
Exit_ErrHandler:
    Exit Function
    
ErrHandler:
    MsgBox "Error " & Err.Number & " in ShowNavigationPane routine : " & Err.description, vbOKOnly + vbCritical
    Resume Exit_ErrHandler

End Function

Public Function HideNavigationPane()

On Error GoTo ErrHandler

    DoCmd.NavigateTo "acNavigationCategoryObjectType"
    DoCmd.RunCommand acCmdWindowHide
        
Exit_ErrHandler:
    Exit Function
    
ErrHandler:
    If Err = 3021 Or Err = 2450 Or Err = 3709 Or Err = 2046 Then Exit Function
    MsgBox "Error " & Err.Number & " in HideNavigationPane routine : " & Err.description, vbOKOnly + vbCritical
    Resume Exit_ErrHandler

End Function

Public Function MinimizeNavigationPane()

On Error GoTo ErrHandler

    DoCmd.NavigateTo "acNavigationCategoryObjectType"
    DoCmd.Minimize
        
Exit_ErrHandler:
    Exit Function
    
ErrHandler:
    MsgBox "Error " & Err.Number & " in MinimizeNavigationPane routine : " & Err.description, vbOKOnly + vbCritical
    Resume Exit_ErrHandler

End Function

--------------------
Colin (Mendip Data Systems)
Website, email
Go to the top of the page
 
foxtrojan
post Oct 31 2019, 10:45 PM
Post#7



Posts: 1,189
Joined: 8-May 06
From: Singapore


Thank so much for your codes. That's real great. Fantastic help from you guys.
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    5th April 2020 - 12:00 PM