How to hide the QAT?

Question

Hi. I want to hide the QAT and also the File tab using USys table. How do I proceed?

---

Gheorghe Zibileanu mobile [phone]

Answer 1

Typically, you would not use the USys table to hide the QAT. The QAT is part of the Ribbon. You would normally hide the Ribbon entirely through VBA code or Create your own startup ribbon using the start from scratch setting.

---

Just takes a click to give thanks for a helpful post or answer.
Please vote “Helpful” or Mark as “Answer” as appropriate.
Chris Ward
Microsoft Community Contributor 2012

Answer 2

I am working with web database. It is possible to work with VBA there?

---

Gheorghe Zibileanu mobile [phone]

Answer 3

I think 1 of these links can help you...I haven't ventured into the web side of Access yet.

http://www.accessribbon.de/en/

https://msdn.microsoft.com/en-us/library/office/ff198313.aspx?f=255&MSPPError=-2147217396

https://support.office.com/en-us/article/Customize-the-Ribbon-45e110b9-531c-46ed-ab3a-4e25bc9413de

---

Just takes a click to give thanks for a helpful post or answer.
Please vote “Helpful” or Mark as “Answer” as appropriate.
Chris Ward
Microsoft Community Contributor 2012

Answer 4

Hi sannikolas,

Could you share us why you want to disable QAT and file tab?

>> I am working with web database. It is possible to work with VBA there?

No, VBA is not supported in web database.

>> I want to hide the QAT and also the File tab using USys table

Do you want to hide QAT in web site or when you develop within Access 2010 desktop application? If you want to disable QAT while you are developing, I think you could refer the links from KCDW, or you could refer the link below.

# Disable QAT in Access 2010 Without removing Custom Ribbon

https://social.msdn.microsoft.com/Forums/office/en-US/ad3dea0b-c18e-47c5-afcc-f700ab5bb99c/disable-qat-in-access-2010-without-removing-custom-ribbon?forum=accessdev

If you want to hide it in web site, it is impossible.

Best Regards,

Edward

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.

Answer 5

Hum, with a web database, then the QAT never shows when running the application in a web browser.

It’s possible you’re talking about an Access 2010 web application which can run on both desktop, and run as web. This being the case you can have the autoexec macro run VBA code to hide the QAT when running the application from your desktop, but of course when running web based, then the QAT will not show.

I will also add that the above 2010 web setup is depreciated, and I would not adopt 2010 web applications for any long term project.

Do feel free to expand on the above, but in general for access web applications the QAT and the ribbon do not show, and thus no need exists to hide them.

Regards,

Albert D. Kallal (Access MVP)

Edmonton, Alberta Canada