473,320 Members | 1,950 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

how can I remove quick access toolbar from the application I develop

2
I develop a simple application programme using access 2007. I have succeeded in removing the tabs and ribbon. I now wanted to get rid of the quick access toolbar so that no body can access the access option to change any thing from my database. Please help me, how can I do it?

Thanks.
Jan 18 '13 #1
8 15253
zmbd
5,501 Expert Mod 4TB
Expand|Select|Wrap|Line Numbers
  1. DoCmd.ShowToolbar "Ribbon", acToolbarNo 
Takes care of the Ribbon and the QAT; however, you'll also want a way to re-enable these if you get stuck.
Jan 18 '13 #2
NeoPa
32,556 Expert Mod 16PB
I'm guessing the QAT and the Ribbon are separate items from the question Z. Your post seems to handle the Ribbon (which the OP has already handled). Is there something else for the QAT, or does that command do both?
Jan 19 '13 #3
TheSmileyCoder
2,322 Expert Mod 2GB
That command will do both (atleast when tested in 2010)
Jan 19 '13 #4
zmbd
5,501 Expert Mod 4TB
NeoPa, as per TheSmileyCoder; the code will take care of both and will work for both V2007 (verfied by my Father-In-Law... poor guy, has V2007 :( ) and in V2010 as this is what I use to kill both QAT and Ribbon.

This line of code is also the only reliable way I've found to take the QAT out of action. I've ran across other means; however, simple crashes and goofs in code seemed to return the QAT wherein this one doesn't.
Jan 20 '13 #5
TheSmileyCoder
2,322 Expert Mod 2GB
Note that this also means you cannot code a custom ribbon at the same time. I don't actually know if you can code menu commandbars, with the ribbon toolbar disabled.
Jan 20 '13 #6
sun50
2
please I do not still understand how to use the code to remove the riboon and quick access toolbar, can you please explain the procedure for me so that I can try it.
Thanks.
Jan 21 '13 #7
NeoPa
32,556 Expert Mod 16PB
The exact code is given in post #2. What is it that you don't understand?
Jan 21 '13 #8
zmbd
5,501 Expert Mod 4TB
You can call this in several ways:
From a startup form
From a statup macro
<ctrl><g> and then cut and paste, press enter; however, this will only hold true for that session. - Nice to troubleshoot with as you can close and reopen to get back your tool bars if something goes horribly wrong.

You can also go this route: Customize the Ribbin

Sounds like may be after something different like making the database MDE/ACCDE.



[Z{edit: Just another MS site; however, deals with the topic from v2010 Deploying a Customized Ribbon and Quick Access Toolbar in Office 2010 }]
Jan 21 '13 #9

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: Mauro | last post by:
How can i resize (autoSize) the Quick Launch Toolbar? I try to send TB_AUTOSIZE Message to it but doesn't work. :-( Thx. Mauro. -- Questa è una firma automatica di MesNews. Sito:...
2
by: Stu | last post by:
Hi, If I try to access an application variable from a class I get the error 'Name Application is not declared'. Is ther any (fairly simple) way of getting round this or do I have to pass the...
1
by: GarDavis | last post by:
When the ASP.Net application ends, the Application_OnEnd() method in Global.asax is called. This method calls a utility in a class library to dump information about the ending application. The...
22
by: Jordan S. | last post by:
SQL Server will be used as the back-end database to a non trivial client application. In question is the choice of client application: I need to be able to speak intelligently about when one...
1
by: Wayne | last post by:
I've searched this forum and trawled the wider web and can't find any information on how to hide or disable the A2007 Quick Access Toolbar. The toolbar is not something that one wants available to...
0
by: dstork | last post by:
In Access 2007, does anyone know of any code to position the QAT below the ribbon? This can be done manually but what about through code? ds
4
by: Bob | last post by:
Hi, Can it's possible to use a customized QAT in Access 2007 with a Ribbon using "USysRibbons" ? because in Access options i can't select 2 ribbon name. Thank's
1
by: Heather | last post by:
I keep selecting and selecting, but it just doesn't show up. I also have no button in the ribbon for this, or any ability to get into other modes via the Office button. It's very frustrating; I had...
21
convexcube
by: convexcube | last post by:
Hi everyone, I am trying to create a single window interface for my database. As I am using Access 2007, I have my document layout options set to tabbed documents without displaying documents tabs...
2
by: yatinbvn | last post by:
hi how to remove file access permission in j2me? when i test my application in device or simulator ( i use fileconnection api) it start with popup (popup with "Allow application to open "some...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.