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
> Object Panel Too Small Width And Cannot Get Back, Access 2010    
 
   
techexpressinc
post Jul 11 2018, 01:14 PM
Post#1



Posts: 393
Joined: 6-October 08
From: indiana, usa


I squeezed the width of the object name area too small and cannot the arrows to appear to get it back to a normal size.

Is there any hope or must I get a new copy of the DB and import all my changed objects?

Attached is a picture to explain it better.

Thanks Russ



Attached File(s)
Attached File  OBJECT_PANEL_TOO_SMALL_JULY2018.JPG ( 38.55K )Number of downloads: 3
 
Go to the top of the page
 
jwhite
post Jul 11 2018, 01:21 PM
Post#2


UtterAccess VIP
Posts: 5,818
Joined: 31-August 06
From: North Carolina, USA


Think of the Navigation Pane just like you would any Windows frame - put the mouse cursor on the right edge until the bar with left & right arrows appear, hold down the mouse button and drag the frame to the right.
Go to the top of the page
 
techexpressinc
post Jul 11 2018, 01:29 PM
Post#3



Posts: 393
Joined: 6-October 08
From: indiana, usa


I been trying 30 minutes+. No double arrows will appear.
This post has been edited by techexpressinc: Jul 11 2018, 01:30 PM
Attached File(s)
Attached File  No_Double_Arrows_JULY2018.jpg ( 55.86K )Number of downloads: 0
 
Go to the top of the page
 
isladogs
post Jul 11 2018, 02:06 PM
Post#4



Posts: 636
Joined: 4-June 18
From: Somerset, UK


Paste the code below into a standard module and run it

CODE
Public Function MaximizeNavigationPane()

On Error GoTo ErrHandler

    DoCmd.NavigateTo "acNavigationCategoryObjectType"
    DoCmd.Maximize
        
Exit_ErrHandler:
    Exit Function
    
ErrHandler:
    MsgBox "Error " & Err.Number & " in MaximizeNavigationPane routine : " & Err.Description, vbOKOnly + vbCritical
    Resume Exit_ErrHandler

End Function

This post has been edited by isladogs: Jul 11 2018, 02:06 PM
Go to the top of the page
 
BruceM
post Jul 11 2018, 02:11 PM
Post#5


UtterAccess VIP
Posts: 7,718
Joined: 24-May 10
From: Downeast Maine


Try pressing F11 to collapse the navigation pane, then see if you can expand it from there.
Go to the top of the page
 
techexpressinc
post Jul 11 2018, 02:48 PM
Post#6



Posts: 393
Joined: 6-October 08
From: indiana, usa


Neither worked, I copied a DB version down from the network, with the proper panel and imported my change objects.
Go to the top of the page
 
techexpressinc
post Jul 11 2018, 02:51 PM
Post#7



Posts: 393
Joined: 6-October 08
From: indiana, usa


I confirmed the function key failed by pressing F1 and getting the Help Screen pop-up.

I confirmed the VBA code failed, by setting a break point at the maximum command and the code made it there.

But still a small unusable object panel.

Thanks for trying to help me.

I had this happen a couple years ago and I think the F11 key worked, then.


Go to the top of the page
 
cheekybuddha
post Jul 11 2018, 05:36 PM
Post#8


UtterAccess VIP
Posts: 10,538
Joined: 6-December 03
From: Telegraph Hill


Perhaps this link will help (last post)?
Go to the top of the page
 
techexpressinc
post Jul 12 2018, 07:18 AM
Post#9



Posts: 393
Joined: 6-October 08
From: indiana, usa


YES!! = "I right clicked to get the navigation options and unticked show the search bar"

I knew there was a simple fix. That is the same fix I did 5 years ago, but forgotten.

Thanks,

I am consider the Access Guru at the shop, so I better know the tricks.

Russ yayhandclap.gif




Go to the top of the page
 
cheekybuddha
post Jul 12 2018, 07:24 AM
Post#10


UtterAccess VIP
Posts: 10,538
Joined: 6-December 03
From: Telegraph Hill


thumbup.gif

Kudos goes to Allyson here!

d
Go to the top of the page
 
isladogs
post Jul 12 2018, 08:18 AM
Post#11



Posts: 636
Joined: 4-June 18
From: Somerset, UK


Thanks also from me as I'd forgotten the hide/unhide the Search Bar trick
However, both of the other methods should also have worked
This post has been edited by isladogs: Jul 12 2018, 08:20 AM
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    12th November 2018 - 11:42 PM