Non SendKeys way to minimize A2007 Ribbon?

M

mdlueck

Sr. Application Developer

Local time

Today, 16:44

Joined

Jun 23, 2011

Messages

2,649

• Aug 8, 2012

• #1

Greetings,

Yes vbaInet, it pains me greatly to have stooped to putting one SendKeys call in my application... ( http://www.access-programmers.co.uk/forums/showthread.php?t=218500#post1114474 )

Code:

  'Make sure the Ribbon is minimized
  If MePointer.Application.CommandBars.Item("Ribbon").Height > 80 Then
    SendKeys "^{F1}", False
    DoEvents
  End If

Is there a non SendKeys way to minimize the Ribbon? In my Internet searching, using SendKeys is all I have been able to turn up.

It would be handy if there were a NavigateTo constant similar to the one ( http://www.access-programmers.co.uk/forums/showthread.php?p=1127715&posted=1#post1127713 ) which is for the Navigation Pane. Is there one for the A2007 Ribbon?

 

Last edited: Aug 8, 2012

A

Ari

Registered User.

Local time

Today, 13:44

Joined

Oct 22, 2011

Messages

139

• Aug 9, 2012

• #2

Hi

For the 2007 version does not have a direct command to minimize the ribbon. In Access 2010 the command already exists. See Question 10

http://www.ribbon01.com/tutoriais/faq.asp

 

V

vbaInet

AWF VIP

Local time

Today, 21:44

Joined

Jan 22, 2010

Messages

26,374

• Aug 9, 2012

• #3

Something tells me I've seen an API that does it but I just can't fully recall. I will have to check on another laptop that I use later in the week. Failing that, I would imagine SendKeys is the acceptable method in this instance.

 

M

mdlueck

Sr. Application Developer

Local time

Today, 16:44

Joined

Jun 23, 2011

Messages

2,649

• Aug 9, 2012

• #4

For now SendKeys is at least working... would prefer not to have to call it to be "Keeping Up Appearances", if ja know what I mean!