Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Access 2007?

Posted on 2009-12-29
7
Medium Priority
?
269 Views
Last Modified: 2012-08-14
I am running an Access 2K mdb in Access 2007. In Access 2K under Tools/Startup I shut off the various menus from appearing. Here in Access 2007 a whole bunch of stuff appears on the top. How can I shut them off?
0
Comment
Question by:Jess31
  • 2
  • 2
  • 2
  • +1
7 Comments
 
LVL 5

Expert Comment

by:mkrisz
ID: 26142396
You can't. This is the new ribbon interface.
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 26142423
click on the Customize Quick Access Toolbar down arrow and select Minimize the Ribbon

0
 
LVL 1

Author Comment

by:Jess31
ID: 26142976
where do I find Customize Quick Access Toolbar?
0
Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 26143334
see the highlighted part of the image
CQAT.JPG
0
 
LVL 1

Author Comment

by:Jess31
ID: 26143640
capricorn1,
This seems to minimize it for all apps, can I do it (say in code perhaps?) where it is minimized only for a specific app?
0
 
LVL 7

Expert Comment

by:msacc97
ID: 26166479
Hi Jess31,

- Create the following function in module:

Function fHideRibbon()
DoCmd.ShowToolbar "Ribbon", acToolbarNo
End Function

- Create AutoExec macro (if you do not have one),
- Call the above function from AutoExec macro when your application starts (Action - RunCode, Arguments - fHideRibbon()).

DoCmd.ShowToolbar "Ribbon", acToolbarYes
can be used to show ribbon back

Hope this helps
0
 
LVL 7

Accepted Solution

by:
msacc97 earned 2000 total points
ID: 26166557
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

Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

810 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