Page 1 of 2 12 LastLast
Results 1 to 15 of 18
  1. #1
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,946

    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:	380 
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, 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

  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
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,946
    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, 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
    jocph is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2018
    Posts
    1
    Thank you for this! Will learn much from this database sample.

  5. #5
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,946
    You're very welcome. Glad you liked it.
    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

  6. #6
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,946
    Just to say there is an updated version of this app on my website with significant additional functionality Control Application Interface - Mendip Data Systems

    Click image for larger version. 

Name:	Capture.jpg 
Views:	131 
Size:	169.8 KB 
ID:	44844
    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

  7. #7
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,381
    Colin, wow is your desktop a mess!
    I had a mess too, but did this:

    Create a folder on the desktop named MyShortcuts and move most of that stuff to the folder. You can sort the folder contents making things easier to find.
    You can even place a shortcut to MyShotcuts anywhere convenient.

  8. #8
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,946
    @davegri
    LOL. All the nice things you could have said about my app...but no...you had to comment on my desktop being a mess

    Actually its well organised clutter with each column having 'similar' item shortcuts. Main windows apps on the left, Office apps on the right in alphabetical order and the most regularly used of my own commercial, client and example apps in the next columns on the right! I NEVER save files to the desktop so loading time is fast

    In fact, I used to use exactly the system you described but scrapped it as it meant having to open the Shortcuts folder(s) to get access to my commonly used apps every time. Having a sparse desktop just wasted a lot of time

    Anyway, everyone to their own approach!
    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

  9. #9
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,381
    Quote Originally Posted by isladogs View Post
    @davegri
    LOL. All the nice things you could have said about my app...but no...you had to comment on my desktop being a mess

    Actually its well organised clutter with each column having 'similar' item shortcuts. Main windows apps on the left, Office apps on the right in alphabetical order and the most regularly used of my own commercial, client and example apps in the next columns on the right! I NEVER save files to the desktop so loading time is fast

    In fact, I used to use exactly the system you described but scrapped it as it meant having to open the Shortcuts folder(s) to get access to my commonly used apps every time. Having a sparse desktop just wasted a lot of time

    Anyway, everyone to their own approach!
    As you say, organization is key to finding what's needed!
    And the app IS fantastic and useful.

  10. #10
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,946
    Quote Originally Posted by davegri View Post
    As you say, organization is key to finding what's needed!
    And the app IS fantastic and useful.
    Ha! Now do I believe you or are you just trying to make amends!!!!!????
    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

  11. #11
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,381
    Ha! Now do I believe you or are you just trying to make amends!!!!!????
    I can pretty much guarantee that I will be able to use your code and concepts to make development life easier.

  12. #12
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,946
    LOL! Its OK...I've been winding you up! Apologies!
    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

  13. #13
    moke123's Avatar
    moke123 is online now Me.Dirty=True
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Ma.
    Posts
    1,641
    Quote Originally Posted by davegri View Post
    Colin, wow is your desktop a mess!
    I had a mess too, but did this:

    Create a folder on the desktop named MyShortcuts and move most of that stuff to the folder. You can sort the folder contents making things easier to find.
    You can even place a shortcut to MyShotcuts anywhere convenient.
    Colin's looks a lot better than mine.

    When I want to look organized I just right click the desktop and unselect show desktop icons.
    If this helped, please click the star * at the bottom left and add to my reputation- Thanks

  14. #14
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,819
    Well here is mine. rofl
    Attached Thumbnails Attached Thumbnails desktop.png.jpg  
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  15. #15
    moke123's Avatar
    moke123 is online now Me.Dirty=True
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Ma.
    Posts
    1,641
    Scanning IP addresses for any nefarious reasons, Gasman?
    If this helped, please click the star * at the bottom left and add to my reputation- Thanks

Page 1 of 2 12 LastLast
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, 10:39 AM
  2. Replies: 6
    Last Post: 07-22-2014, 03:18 AM
  3. Replies: 5
    Last Post: 03-28-2014, 11:28 AM
  4. Replies: 6
    Last Post: 10-30-2013, 02:47 PM
  5. Replies: 1
    Last Post: 03-20-2013, 07: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
  •  
Other Forums: Microsoft Office Forums