none
How to hide the QAT? RRS feed

  • Question

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

    Gheorghe Zibileanu mobile 0040740999006


    • Edited by sannikolas Thursday, April 7, 2016 10:52 AM
    Thursday, April 7, 2016 10:50 AM

Answers

  • 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.


    Friday, April 8, 2016 6:14 AM
  • 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

    Saturday, April 9, 2016 1:12 AM

All replies

  • 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

    Thursday, April 7, 2016 2:40 PM
  • I am working with web database. It is possible to work with VBA there?

    Gheorghe Zibileanu mobile 0040740999006

    Thursday, April 7, 2016 5:17 PM
  • 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

    Thursday, April 7, 2016 6:57 PM
  • 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.


    Friday, April 8, 2016 6:14 AM
  • 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

    Saturday, April 9, 2016 1:12 AM