Run button for Queries disappears?

[jsteph]

Hi all,
Why does the red bang (Query-Run) button disappear? And it doesn't matter what 'ribbon tab' I'm in--it's gone from every and all tabs after some unknown sequence of events.

Yes I know I can right click on the query and choose 'datasheet view' to run it, but I'd really like that run button and really would like to know why Access 2010 has the worst user interface that could possibly have been dreamed up.
Thanks,
--Jim

 

[lameid]

I have not seen that one unless you mean the tab on the ribbon is changed and you can't see it without changing it back....

But agreed, the Ribbon is a horrible concept in Access... Seems to work well in Excel... Then again I don't use Excel that much.

 

[jsteph]

Yes...when in query design (seems to be after a 'query wizard'), then the "Design" tab of the ribbon disappears, so I can't use the Run button.

After some odd sequence of spells, potions, and chants, the Design tab re-appears at random.

But a further issue is, the 'design' and 'create' tabs should be all in one because the 'Query Design' button is in the 'Create' tab, and if I hit that or the 'Query Wizard' button in the Create tab while another query is open, it ASSUMES I want to 'create' a query based on the object that happens to be selected, and gives me an odd error message that I have to:

"Save the current query before creating another object based on it".

What?????????? How does it get the idea that I want to create a new query based on the object that I happened to last touch? Just bad, bad, bad UI design. The idiots are back.
--Jim

 

[lameid]

I have found that when the ribbon collapses, you can double click the tab to expand it back up, similarly double clicking the tab makes will collapse it if it is full sized.

You may want to tinker with the QAT or Quick Access Toolbar ribbon. BTW Access in QAT means ease of use and not the product as Ribbons are common to all office apps. That piece of information can come in handy if you go down the rabbit hole of building your own ribbon, which it sounds as though you are frustrated enough to do. My personal favorite though is if I add a button to the QAT to design something... it always does forms or presumably whatever object I happened to pick... I may have just not figured it out yet.

But I agree I am forever wanting to click across 2 or more tabs Especially when designing a form... particularly in forms I want the control box on the <I think> design tab and the entire format tab. Add this control, format, repeat. Annoying. In Excel, I do not have any major gripes... but then again Access has always been that foster child 'welcomed' into the family for the money. All was well and good before they decided to standardize the interface across all office Apps... Remember being able to build references in code like you can still in queries?