Results 1 to 5 of 5
  1. #1
    Eranka is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Dec 2017
    Posts
    150

    Hide Bar In Access

    Click image for larger version. 
<br /><script async src=
    Name: 01.jpg  Views: 11  Size: 149.1 KB  ID: 36299" class="thumbnail" style="float:CONFIG" />


    Hi Everyone

    Please see the above image. How to hide the menu bar (as shown in the image) using vba code

    I tried
    Code:
    DoCmd.ShowToolbar "Ribbon", acToolbarNo
    but is does not hide the highlighted bar.

  2. #2
    GinaWhipp's Avatar
    GinaWhipp is offline Competent Performer
    Windows 7 64bit Access 2013 32bit
    Join Date
    Jul 2011
    Location
    Ohio, USA
    Posts
    377
    That is the Access window so the Toolbar line will not work. Never tried but have a look at...
    https://accessexperts.com/blog/2015/...cess-tutorial/

    I would test on a copy before implementing.
    Last edited by GinaWhipp; 11-22-2018 at 11:14 PM. Reason: Additional info

  3. #3
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,977
    Have a look at my example app showing different ways of controlling the application interface including what you want
    http://www.mendipdatasystems.co.uk/c...ace/4594365418
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  4. #4
    Eranka is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Dec 2017
    Posts
    150
    Hi

    Ridders your code work upon a button click. but i want to do it while the application opens. form load. how to do this part?

  5. #5
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,977
    Jut place the relevant functions in an autoexec macro at these will run at start up.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

Please reply to this thread with any new information or opinions.

Similar Threads

  1. How to hide the All access objects window?
    By dollygg in forum Forms
    Replies: 3
    Last Post: 03-16-2017, 12:37 PM
  2. Hide Access and show only my forms
    By mortenskipper in forum Access
    Replies: 8
    Last Post: 01-20-2016, 08:21 AM
  3. Open Form Hide Access
    By crimedog in forum Forms
    Replies: 6
    Last Post: 12-12-2014, 01:27 PM
  4. Hide access on start up
    By beha in forum Access
    Replies: 3
    Last Post: 01-06-2012, 04:57 PM
  5. Replies: 1
    Last Post: 06-20-2010, 05:04 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums