Force Database Window Size

[Guest]

Hi, everyone!

Is there any way (Database settings, VBA code, macro, etc.) to force an A2K
database window to be a certain size when the database is opened? This
would, preferably, not affect the size of a different .mdb when it is opened.

Thanks,
Bruce

 

[Marshall Barton]

Is there any way (Database settings, VBA code, macro, etc.) to force an A2K
database window to be a certain size when the database is opened? This
would, preferably, not affect the size of a different .mdb when it is opened.

Use the MoveSize action in your AutoExec macro.

 

[Guest]

Sorry, Marsh, but that's not the result I want. What I was shooting for was
to set the size of the MS Access application window.

What I had: "Splash" form set to load in the Startup Options. AutoExec
macro with only MoveSize command.
Result: "Splash" opens at startup, then resizes to specs in MoveSize.
(Size of Access "container" window did not change.)

What I tried: Removed "Splash" from Startup Options and put in an OpenForm
for it following the MoveSize in the AutoExec macro.
Result: Macro error. Guessing that it happens because there's no form open
at the time the MoveSize is called.

Any way to set the size of the MS Access application "container" window at
start up? Don't care if they drag the corner to re-size after it starts, but
I'd like the app to come up looking it's best.

Thanks,
Bruce

Bruce

 

[Marshall Barton]

Sorry, I thought you were asking about the Database window.

The Access window is controled by Windows and would need to
be manipulated by Windows API code. See
http://www.mvps.org/access/api/api0019.htm

 

[Van T. Dinh]

See the Microsoft Knowledge Base article:

http://support.microsoft.com/kb/210085

 

[Guest]

Van,

Worked great! Easy to implement!

Thanks!
Bruce

 

[Guest]

Marsh,
Thanks for the help!
Bruce

Sorry, I thought you were asking about the Database window.

The Access window is controled by Windows and would need to
be manipulated by Windows API code. See
http://www.mvps.org/access/api/api0019.htm
--
Marsh
MVP [MS Access]

Sorry, Marsh, but that's not the result I want. What I was shooting for was
to set the size of the MS Access application window.

What I had: "Splash" form set to load in the Startup Options. AutoExec
macro with only MoveSize command.
Result: "Splash" opens at startup, then resizes to specs in MoveSize.
(Size of Access "container" window did not change.)

What I tried: Removed "Splash" from Startup Options and put in an OpenForm
for it following the MoveSize in the AutoExec macro.
Result: Macro error. Guessing that it happens because there's no form open
at the time the MoveSize is called.

Any way to set the size of the MS Access application "container" window at
start up? Don't care if they drag the corner to re-size after it starts, but
I'd like the app to come up looking it's best.

 

[Van T. Dinh]

You're welcome ... Glad you worked it out ...