Maximising window

AndyMcC

New Member
Joined
Nov 27, 2003
Messages
11
I am devising an Excel routine which requires approximately 50 variables to be entered for each calculation. The variables are stored on an Access database and I use an Access form to input these. The bulk of the work is done withing Excel, and those using the routine will be most familiar, and therefore most comfortable, with this application.
My problem is that when I swap from the full page Excel page to the Access one, the Access window is not full screen. Obviously it can be maximised in the top corner, but is there any way of ensuring that this is unnecessary?

:oops:
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

NateO

Legend
Joined
Feb 17, 2002
Messages
9,700
Hello, not sure why you're flipping as you describe, but the following just about ought to do it:

Code:
Public Declare Function ShowWindow& Lib "user32" _
    (ByVal hwnd As Long, ByVal nCmdShow As Long)

Sub jkdsfk()
Call ShowWindow(Application.hWndAccessApp, 3)
End Sub
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,088
Messages
5,768,034
Members
425,451
Latest member
JohnBrooksBiddle

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top