Hi Stuart
Yes – that's what I meant by "the results stay the same …"
I'm just working on some code for you … watch this space :-)
Graham
From: MS_Access_Professionals@stage.yahoogroups.com [mailto:MS_Access_Professionals@stage.yahoogroups.com]
Sent: Friday, 22 August 2014 13:40
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] widths and heights
Hi, I tried this, maybe I am not understanding something. NavPaneClosed returns 0 whether the Nav pane is there or not, and the width always shows 209, even when I change the width. Am I missing something?
Regards, Stuart
On Thursday, August 21, 2014 7:40 PM, "'Graham Mandeno' graham@mandeno.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
Hi Crystal
Thank you! I just learned about some more properties :-)
However … the results stay the same, whether I show/hide the nav pain, or change its width, or show/hide the search bar :-/
-- Graham
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Friday, 22 August 2014 11:29
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] widths and heights
Sub NavPane()
With CurrentDb
Debug.Print "Show Navigation Pane Search Bar = "; .Properties("Show Navigation Pane Search Bar")
Debug.Print "NavPane Closed: "; .Properties("NavPane Closed")
Debug.Print "NavPane Width: "; .Properties("NavPane Width")
End With
End Sub
someone else can jump in on the ribbon part of your question ...
Warm Regards,
Crystal
Remote Programming & Training -- connect to me, let's build it together
Code Documenter for Access
http://www.accessmvp.com/strive4peace/CodeDocumenter.htm
Through sharing, we will all get better
~ have an awesome day ~
| ||||||
| | | | | ||
Download Crystal's Code Documenter Please send me your comments and ideas! This also documents MDB files. Watch for updates. Access 2007+ version Crystals_CodeDocumenter_120204_2p_BETA_ACCDE_TXT.zip | ||||||
Preview by Yahoo | ||||||
| ||||||
On Thursday, August 21, 2014 1:11 PM, "Stuart Schulman stoughy@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
Is there any way (Access 2007) to determine the width of the navigation pane? Or the height of the ribbon?
Thanks, Stuart
Posted by: "Graham Mandeno" <graham@mandeno.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (5) |
Tidak ada komentar:
Posting Komentar