Go Back   Access World Forums > Microsoft Access Reference > Code Repository

 
Reply
 
Thread Tools Rating: Thread Rating: 2 votes, 5.00 average. Display Modes
Old 05-04-2017, 04:50 PM   #1
ridders
AWF VIP
Gold Supporter
 
ridders's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 2,586
Thanks: 43
Thanked 603 Times in 558 Posts
ridders has a spectacular aura about ridders has a spectacular aura about
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

This item links to various posts in the thread:
https://www.access-programmers.co.uk...d.php?t=284248

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



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.
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 parts are written by myself or other authors.
Where this is the case, those authors have been acknowledged.

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
Attached Images
File Type: gif SetWindowsApp.gif (46.2 KB, 878 views)
Attached Files
File Type: accdb SetWindows.accdb (1.74 MB, 271 views)

__________________
Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
, Tapatalk


If this answer has helped, please click the Thanks button and/or click the 'reputation' scales symbol on the left and leave a comment. Cheers!

Last edited by ridders; 05-21-2017 at 09:35 AM.
ridders is offline   Reply With Quote
The Following 3 Users Say Thank You to ridders For This Useful Post:
ashleedawg (06-21-2017), Eljefegeneo (05-04-2017), Groundrush (05-11-2017)
Old 06-21-2017, 11:08 PM   #2
ashleedawg
"Here for a good time"
 
ashleedawg's Avatar
 
Join Date: Jun 2017
Location: Canada
Posts: 152
Thanks: 18
Thanked 37 Times in 34 Posts
ashleedawg is on a distinguished road
Re: Show/hide application window, navigation pane, ribbon, taskbar

@ridders I created an account just because it was imperative for me to thank you for this post. I've been researching & experimenting for a week, trying to get some control over the Access window and such, and you have so much good stuff summed up in one place!

(I know not all the code is yours but you're the one that compiled, and made it find-able, and that's what counts!)

Thanks a bunch!
ashleedawg is offline   Reply With Quote
Old 07-15-2017, 03:25 AM   #3
ridders
AWF VIP
Gold Supporter
 
ridders's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 2,586
Thanks: 43
Thanked 603 Times in 558 Posts
ridders has a spectacular aura about ridders has a spectacular aura about
Re: Show/hide application window, navigation pane, ribbon, taskbar

Just had some feedback that this didn't run in 64-bit Access

I've updated the Windows API calls so that it will now also run in 64-bit Access for those of you that use it
Attached Files
File Type: accdb SetWindows.accdb (1.74 MB, 92 views)

__________________
Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
, Tapatalk


If this answer has helped, please click the Thanks button and/or click the 'reputation' scales symbol on the left and leave a comment. Cheers!
ridders is offline   Reply With Quote
The Following User Says Thank You to ridders For This Useful Post:
SJS66 (08-09-2017)
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Show/Hide navigation pane via VBA? Big Pat Modules & VBA 4 07-15-2015 05:47 PM
Hide and show Ribbon and Navigation Pane OBBurton Modules & VBA 5 08-29-2014 03:53 AM
Ribbon + navigation pane lock/Hide on loading... HRakibul Modules & VBA 5 08-20-2014 12:56 AM
Setting the Ribbon Name, and Show Navigation Pane in VBA Fazered Modules & VBA 2 11-19-2008 12:20 PM




All times are GMT -8. The time now is 11:32 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World