[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Prevent ribbon from showing when datasheet subform has the focus in Access 2010

Posted on 2011-05-03
15
Medium Priority
?
1,496 Views
Last Modified: 2012-05-11
I'm experiencing an annoying problem in Access 2010. This doesn't appear to be happening in 2007.  In my application I hide the ribbon at startup. The only time I want to see a ribbon is when i run reports and those are custom ribbons. all this works great except in 2010. If I have a main form with a datasheet subform, then the app displays a default ribbon when the subform has the focus. This causes the entire window to shift down.  when the main form loads the ribbon is minimized, but if I run code to change the record source of the subform then the focus goes to the first record of the subform, a ribbon is maximized and the window shifts down to accomodate it.
0
Comment
Question by:BradleyCleveland
  • 7
  • 5
  • 2
  • +1
15 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 35515371
Perhaps this will be addressed in a future Service pack.

Since what you are doing is somewhat specialized, your best bet may be to contact MS directly on this...


JeffCoachman
0
 
LVL 17

Expert Comment

by:JezWalters
ID: 35516025
Have you tried minimising/hiding the ribbon from the appropriate event handlers of your sub-form?
0
 
LVL 1

Author Comment

by:BradleyCleveland
ID: 36342088
boag2000: How do I contact MS on this?  I don't want to pay them for support on a problem that is theirs.
JezWalters: Yes I have tried minimising the ribbon, but without success. I have tried setting the properties to NO Ribbon and to a default custom ribbon that has no buttons. Neither option worked. Here is the code I use for minimizing which appears to work except for situations where the subform is in datasheet view or continous records. This problem only happens on 2010, not 2007. The ribbon that appears is one that is designed for datasheets that allows adding alternating row colors, conditional formatting, etc.

If SysCmd(acSysCmdAccessVer) > 12 Then
    If CommandBars.Item("Ribbon").Height > 100 Then
        CommandBars.ExecuteMso "MinimizeRibbon"
    End If
End If
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36343478
<boag2000: How do I contact MS on this?  I don't want to pay them for support on a problem that is theirs.>
Up to you, ...but if your goal is to resolve the issue, and time is a factor, ...this may be your best Option.


This is yet another reason why I try to build my custom functionality into my forms, hence no "ribbon" issues.

Can you post a screencast of this phenomenon in Access 2007 and in Access 2010?
0
 
LVL 1

Author Comment

by:BradleyCleveland
ID: 36402379
Here's the pictures:
 Access 2007 File Access 2010 file
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36404436
The "Ribbon" functionality in Access 2010 is slightly different form that of 2007.
If you notice, in 2010 it is more of a Ribbon/Menubar hybrid

Again, this is why I try to load all of my functionality on a form, and only use the ribbon if no other option is available.

This eliminates any issues of jerking around with the ribbon deciding when certain ribbons/ribbon options should display.

You stated that: "The only time I want to see a ribbon is when i run reports"
What ribbon functionality are you implementing that you could not put on a form?

JeffCoachman
0
 
LVL 1

Author Comment

by:BradleyCleveland
ID: 36405954
We use several customized ribbons for the reports that includes buttons to custom coding routines and export functions. I would think that there should be a way to suppress a ribbon for specific forms. This ribbon displays when the focus is in the datasheet subform and then disappears when the focus is in one fo the fields in the main form.  This is extremely annoying.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36410197
<I would think that there should be a way to suppress a ribbon for specific forms.>
There very well might be.

But if this is something you can "Live with" for as long as it takes to find a solution, then you can wait...
perhaps an Expert familiar with ribbon manipulation in 2010 will chime in.


<How do I contact MS on this?  I don't want to pay them for support on a problem that is theirs.>
Perhaps they don't see it that way...
;-)

Again is this something you can wait on?
I mean if you pay them $60 and they fix the issue in 20 minutes, would that be worth it?

JeffCoachman
0
 
LVL 1

Author Comment

by:BradleyCleveland
ID: 36492730
Ok.  EE is marking this question as abandoned. Anymore ideas?  Anybody know the phone number to Microsoft Office tech support?
0
 
LVL 75
ID: 36492748
Office Tech Support :  800-936-4900  06:00 to 18:00 PDT
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36493273
LOL
Joe, where did you come from?
0
 
LVL 1

Author Comment

by:BradleyCleveland
ID: 36584619
I was about to call tech support, but I think I may have resolved the problem.  I am trying adding my orginal minimize code to the onfocus event of controls on the subform.  I should know in a few days if this is going to work.
0
 
LVL 1

Accepted Solution

by:
BradleyCleveland earned 0 total points
ID: 37202156
I have stumbled across something that fixed this problem.  When I load my database I have a custom ribbon that is basically just blank. Following are some lines of xml code that I can add to that ribbon to prevent the datasheet ribbon from showing.

<contextualTabs>
  <tabSet idMso="TabSetFormDatasheet" visible="false" />
</contextualTabs>

Since I have found the resolution elsewhere I am going to request that this question be closed.
0
 
LVL 1

Author Closing Comment

by:BradleyCleveland
ID: 37230492
Since I found the resolution elsewhere, I am accepting my own answer as the correct answer.
0
 
LVL 75
ID: 37202670
Good find!  Can you post all the XML for the ribbon table ?

thx.mx
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question