Maximising window

AndyMcC

New Member
Joined
Nov 27, 2003
Messages
15
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

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

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
 
Upvote 0

Forum statistics

Threads
1,187,172
Messages
5,962,029
Members
438,575
Latest member
aleksa02

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