Go Back   Access World Forums > Microsoft Access Reference > Sample Databases

 
Closed Thread
 
Thread Tools Rating: Thread Rating: 6 votes, 5.00 average. Display Modes
Old 08-11-2019, 12:50 PM   #16
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 10,980
Thanks: 114
Thanked 3,003 Times in 2,730 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Show/hide application window, navigation pane, ribbon, taskbar

Hi reinier
I'm a little confused here.
The default situation is that the application window, taskbar etc are visible.
The example app is designed to prevent all of that.

If you use my code to 'maximise the form', you can also hide the taskbar and fill that space with your form...but that is optional. If you don't want that behaviour, don't use it.

BTW I've deleted your duplicate posts which were also moderated.

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
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.
,
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.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin (Mendip Data Systems)
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.


"As we know, there are known knowns; there are things we know we know. We also know there are known unknowns; that is to say we know there are some things we do not know. But there are also unknown unknowns the ones we don't know we don't know. It is the latter category that tend to be the difficult ones" Donald Rumsfeld
isladogs is offline  
Old 08-11-2019, 01:01 PM   #17
theDBguy
Im here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 5,783
Thanks: 57
Thanked 1,267 Times in 1,248 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Show/hide application window, navigation pane, ribbon, taskbar

Quote:
Originally Posted by Reinier View Post
Hello everybody, this is my first post here.

I saw the great coding with hide/show ribbon, taskbar etc etc.

I used the lastest project v3.41, trying to make a startup form,
maximised + taskbar.
I used the code behind the buttons, to make this happen, BUT...

the form does maximise, but the taskbar just will not appear, using VBA.

(the buttons work very nice)

What am I doing wrong???

(After 2 days of trying and thinking, I ran out of options)

THANKS !!!!!!!
Hi. Welcome to AWF! Not sure we can tell you what you did wrong if we can't see what it was exactly that you did. Are you able to post a copy of your db?
__________________
Just my 2 cents...

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.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline  
Old 08-11-2019, 02:19 PM   #18
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 10,980
Thanks: 114
Thanked 3,003 Times in 2,730 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Show/hide application window, navigation pane, ribbon, taskbar

If you want to post a copy of your db, please do so to a new thread as this is a moderated area

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
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.
,
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.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin (Mendip Data Systems)
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.


"As we know, there are known knowns; there are things we know we know. We also know there are known unknowns; that is to say we know there are some things we do not know. But there are also unknown unknowns the ones we don't know we don't know. It is the latter category that tend to be the difficult ones" Donald Rumsfeld
isladogs is offline  
Old 08-13-2019, 01:26 PM   #19
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 10,980
Thanks: 114
Thanked 3,003 Times in 2,730 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Show/hide application window, navigation pane, ribbon, taskbar

I've discovered a couple of bugs in v3.41
The new code suggested by daolix (see post #14) is preventing the ribbon code working and that also means the form properties sheet isn't visible in design view

I'm hoping daolix will see this post and assist as at the moment I don't have a solution.
However the rest of the example app appears to still work perfectly
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
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.
,
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.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin (Mendip Data Systems)
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.


"As we know, there are known knowns; there are things we know we know. We also know there are known unknowns; that is to say we know there are some things we do not know. But there are also unknown unknowns the ones we don't know we don't know. It is the latter category that tend to be the difficult ones" Donald Rumsfeld
isladogs is offline  
Old 08-14-2019, 06:58 AM   #20
theDBguy
Im here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 5,783
Thanks: 57
Thanked 1,267 Times in 1,248 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Show/hide application window, navigation pane, ribbon, taskbar

Quote:
Originally Posted by isladogs View Post
I've discovered a couple of bugs in v3.41
The new code suggested by daolix (see post #14) is preventing the ribbon code working and that also means the form properties sheet isn't visible in design view

I'm hoping daolix will see this post and assist as at the moment I don't have a solution.
However the rest of the example app appears to still work perfectly
Hi Colin. Did you see daolix's reply in this thread?
__________________
Just my 2 cents...

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.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline  
Old 08-14-2019, 07:19 AM   #21
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 10,980
Thanks: 114
Thanked 3,003 Times in 2,730 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Show/hide application window, navigation pane, ribbon, taskbar

Hi DBG
I did indeed & have been working on it for the past hour or so.

Thanks to daolix's prompt intervention, I've been able to fix the bugs mentioned in post #19.
I had to make quite a few other tweaks to fix the interaction between the different parts of the application and daolix's code which was added to fix the issue where clicking the taskbar icon restored the application window.
AFAIK all features are now working again with no nasty surprises.

Updated version 3.44 attached - no new features but hopefully now bug free once again.
Feedback particularly welcomed from anyone running 64-bit

For info, I did some testing of the rather complex (to me) code line originally suggested by daolix and used in v3.4 onwards
Code:
 SetWindowLong Me.hWnd, GWL_EXSTYLE, GetWindowLong(Me.hWnd, GWL_EXSTYLE) Or WS_EX_APPWINDOW
I tried splitting the final argument into two parts:

Omitting the 'GetWindowLong(Me.hWnd, GWL_EXSTYLE)' part SEEMS to have no effect on its function that I noticed - can anyone explain what it does? MS documentation says GWL_EXSTYLE sets a new extended windows style

Omitting the 'Or WS_EX_APPWINDOW' part hides the taskbar icon completely.
For most people that would seem to be undesirable BUT I remember someone wanted that exact feature with the app window hidden a couple of years ago.
I've no idea who it was now but what I do remember is that they never explained why they wanted it!
If he/she is reading this now...here is your solution
Attached Files
File Type: zip SetWindows - v3.44.zip (311.8 KB, 121 views)
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
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.
,
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.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin (Mendip Data Systems)
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.


"As we know, there are known knowns; there are things we know we know. We also know there are known unknowns; that is to say we know there are some things we do not know. But there are also unknown unknowns the ones we don't know we don't know. It is the latter category that tend to be the difficult ones" Donald Rumsfeld

Last edited by isladogs; 08-14-2019 at 03:17 PM. Reason: Replaced attachment with v3.44
isladogs is offline  
The Following User Says Thank You to isladogs For This Useful Post:
haliliyas (10-13-2019)
Old 09-07-2019, 02:58 AM   #22
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 10,980
Thanks: 114
Thanked 3,003 Times in 2,730 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Show/hide application window, navigation pane, ribbon, taskbar

Here are two more variations on a theme requested by various forum members but which may be useful to others. Each should work in both 32-bit & 64-bit Access

1. Title Bar Only (requested by UA member tina_t via a PM)
The OP wanted the application window to be retained but with the title bar only - no nav pane or ribbons:

i) This approach works best with overlapping windows.
ii) The form MUST be a popup

2. Remove Title Bar Buttons ( requested by AWF member joeyd11ph in Shutdown PC through Access button

The OP wanted all buttons removed from the title bar in order to control Access closedown via code only.

i) This approach only works with overlapping windows.
ii) The form MUST be a popup with NO control box, close, max/min buttons
iii) To remove the title bar as well, set form border style to None

In addition, he wanted to know how to other actions such as log off or shut down the PC completely using code for which I supplied the following code. Place in a standard module

Code:
Option Compare Database
Option Explicit

'NOTE switches used below
/s = shutdown
/r = reboot
/l = logoff
/f = force apps to close without warning
/t xxx = time delay of xxx seconds e.g. /t 2

' ‘*******************SHUT DOWN*********************
Public Function TurnOff()
    
    Shell "shutdown /s /t 2", vbHide
    Application.Quit
End Function
 
' ‘*********************REBOOT***********************
Public Function Reboot()
    Shell "shutdown /r /t 2", vbHide
    Application.Quit
End Function
 
' ‘*********************LOG OFF***********************
Public Function LogOff()
    'omit /t switch or it doesn't work
    Shell "shutdown /l", vbHide
    Application.Quit
End Function
 
 '‘**********************FORCE************************
Public Function ForceReboot()
    Shell "shutdown /r /f /t 3", vbHide
    Application.Quit
End Function
NOTE:
With any code of this type, I suggest adding a warning message so user has to confirm action before it runs. Once implemented, the process cannot be interrupted! For that reason, I also advise users that all work should be saved first

====================================
As this thread is closed, if you have any comments or questions, please send me a PM or start a new thread linking back to this one.
Attached Files
File Type: zip RemoveTitleBarButtonsExample.zip (33.1 KB, 50 views)
File Type: zip TitleBarOnly.zip (28.1 KB, 48 views)


__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
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.
,
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.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin (Mendip Data Systems)
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.


"As we know, there are known knowns; there are things we know we know. We also know there are known unknowns; that is to say we know there are some things we do not know. But there are also unknown unknowns the ones we don't know we don't know. It is the latter category that tend to be the difficult ones" Donald Rumsfeld

Last edited by isladogs; 10-15-2019 at 10:37 AM. Reason: Changed order of text
isladogs is offline  
Closed Thread

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 05:00 AM.


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

Featured Forum post


Sponsored Links


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