Results 1 to 3 of 3

Show/hide application window, navigation pane, ribbon, taskbar

  1. #1
    ridders52's Avatar
    ridders52 is offline Long time standing
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    1,337

    Show/hide application window, navigation pane, ribbon, taskbar

    I have created an example database to show how the Access application interface can be controlled in various ways.
    Some of these methods can be used to make a database more secure.

    It is intended to demonstrate that all of this is easy to do safely and without any issues arising

    SetWindows.zip

    The database is opened with form frmStart 'floating independently' on the desktop i.e. with the access application window hidden

    Click image for larger version. 

Name:	SetWindows.jpg 
Views:	67 
Size:	184.5 KB 
ID:	31930




    Buttons on the form can be used to:
    - show / hide entire Access application window
    - show / hide navigation pane
    - show / hide ribbon
    - show / hide taskbar
    - maximise the form to fill the entire screen (no title bar & no taskbar) - this only works for a popup form
    - open another form with a related report. This shows how the print preview ribbon can be displayed whilst the report is open & hidden when it is closed
    - open / close the VBE

    Although it is highly unlikely that any single application would need to use all of these features, this is designed to show that all items can be toggled on / off independently without problems.

    All code has been fully tested in Access 2010 & 2016 (32-bit & 64-bit)
    In addition, each section of the code has been widely used in various production databases for several years.

    The code used can be found in the modules: modDatabaseWindow / modNavPaneTaskbar / modRibbon

    Some of the code is widely known e.g. hide navigation pane / ribbon.
    Other code was written by myself or other authors (acknowledged where applicable).

    This example database also includes:
    - code to resize forms for any screen size & resolution (modResize module)
    - additional functions in module modDesignFeatures

    If you wish to use any of the code in your own projects, just copy the relevant module code including all author information as supplied

    The VBA reference Visual Basic for Extensibility is required for certain additional functions listed in the module modDesignFeatures
    e.g. CloseAllVBEWindows and for getting the procedure names in error handling code.
    It can be omitted if you don't wish to use either of these

    I hope this is useful to others
    Do contact me if you have any questions or problems with the attached code
    Colin (Mendip Data Systems), Website, email

    If this has helped, please click the star button and leave a comment

  2. #2
    calaxan's Avatar
    calaxan is offline Novice
    Windows 7 32bit Access 2013 32bit
    Join Date
    Jan 2018
    Posts
    9
    Many Thanks...

  3. #3
    ridders52's Avatar
    ridders52 is offline Long time standing
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    1,337
    You're welcome. I regularly use aspects of this in many of my own databases e.g. hide app window/ribbon/taskbar/nav pane etc
    Colin (Mendip Data Systems), Website, email

    If this has helped, please click the star button and leave a comment

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

Similar Threads

  1. Code for button to show Navigation Pane
    By MTSPEER in forum Programming
    Replies: 6
    Last Post: 07-27-2016, 09:39 AM
  2. Replies: 6
    Last Post: 07-22-2014, 02:18 AM
  3. Replies: 5
    Last Post: 03-28-2014, 10:28 AM
  4. Replies: 6
    Last Post: 10-30-2013, 01:47 PM
  5. Replies: 1
    Last Post: 03-20-2013, 06:04 AM

Tags for this Thread

Posting Permissions

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