I want the ms access application window size to be fixed (height width etc) on restore command only.
On close I am using command
But this restores to the size where user has already stretched the application to whatever extent. Meaning this restore size will be different on different PCs.
In this case, at very beginning at user login, user login form will open to that size (vary PC to PC on distribution). I want to be fixed at beginning /on app open.
Like we use it for forms for example
Me.InsideHeight = 2 * 3750
Me.InsideWidth = 5 * 2837
But this is for forms. I want for main app.
is there way to do that for app window on restore only (on close)?? thanks
Some one may ask why.... briefly.
1) login forms opens in small window, (popup = no), and on load: DoCmd.ShowToolbar "Ribbon", acToolbarNo
2) Dashboard opens with app maximized size.
3) on close app size is resotored.
Beautiy of this is it gives a software look, and is very flexible users can minimize, maximize, move the software to another 2nd screen, any popup forms can move to another screen.
On close I am using command
Code:
DoCmd.RunCommand acCmdAppRestore
In this case, at very beginning at user login, user login form will open to that size (vary PC to PC on distribution). I want to be fixed at beginning /on app open.
Like we use it for forms for example
Me.InsideHeight = 2 * 3750
Me.InsideWidth = 5 * 2837
But this is for forms. I want for main app.
is there way to do that for app window on restore only (on close)?? thanks
Some one may ask why.... briefly.
1) login forms opens in small window, (popup = no), and on load: DoCmd.ShowToolbar "Ribbon", acToolbarNo
2) Dashboard opens with app maximized size.
3) on close app size is resotored.
Beautiy of this is it gives a software look, and is very flexible users can minimize, maximize, move the software to another 2nd screen, any popup forms can move to another screen.
Last edited: