Hide all Access Windows and Ribbons (1 Viewer)

alvingenius

IT Specialist
Local time
Today, 19:05
Joined
Jul 10, 2016
Messages
169
Hello

I wanna open db forms as in popup window in all forms and i don't wanna see Access window at all + ribbons + nav pan

i've managed to hide nav panel from access options in CURRENT DATABASE

and managed to hide ribbon with this code

DoCmd.ShowToolbar "Ribbon", acToolbarNo

Now i want to hide Access Window

Check this photo from what i mean





EDIT :
Check this post to make it work
 

Attachments

  • app.jpg
    app.jpg
    48.8 KB · Views: 306
Last edited:

alvingenius

IT Specialist
Local time
Today, 19:05
Joined
Jul 10, 2016
Messages
169

that's perfect

thanks @isladogs

just imported module : modDatabaseWindow from your example

and used

Me.Painting = False
SetWindowLong Me.hWnd, GWL_EXSTYLE, GetWindowLong(Me.hWnd, GWL_EXSTYLE) Or WS_EX_APPWINDOW
ShowWindow Application.hWndAccessApp, SW_HIDE
ShowWindow Me.hWnd, SW_SHOW

in every form Load Event

Question to @isladogs
why it's not applied to all forms since i applied it in intro form ?
because if i didn't put the same code in the every other form i call from intro form it wont open or it opened hidden !?
 

isladogs

MVP / VIP
Local time
Today, 17:05
Joined
Jan 14, 2017
Messages
18,186
Alvin
This type of code is stopping Access behave as it normally does which would be to display the application window, ribbon etc. Getting it to work reliably in all situations needs care.
Changing forms will by default restore the application window. To prevent that you need to reapply at least part of the code.

Compare the results when new form are opened with the buttons 'Open New Form' and 'Open Form Query'. The first restores the app window, the second doesn't. Compare the code used in each case both on the main form frmStart and the called forms
 

Users who are viewing this thread

Top Bottom