SubClassing to set minimum size for Access main window

[Max Moor]

Hi All,
As the subject line says, I'm trying to set the minimum size for my
main Access window. I ran across a knowledge base article that seemed
promising...

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

As a first cut, I just copied the code like it says to, and fired it
up. Sadly, no matter how I resize the main Access window, the code in the
WM_GETMINMAXINFO If never runs.

It doesn't seem to hurt anything at the outset, but after 10-20
seconds, Access all but locks up. I can close a couple of forms, but the
screen doesn'l redraw properly, and I can't do anything with the form that
has the subclassing code hooked to it. I have to kill Access form the
Windows Task Manager to get out of it.

Has anyone used subclassing like this successfully? Can you offer any
advice to me about what might be going wrong? This method seems to be the
thing to do, but this code sure doesn't seem to be hitting the mark.

Regards,
Max

 

[aaron_kempf]

I don't get it-- the main Access window? or the Access form?

I would just reccomend
a) not letting people resize forms. Seriously-- maximize them always.
b) not let people see the db window.

-Aaron

 

[Max Moor]

(e-mail address removed) wrote in @w1g2000prd.googlegroups.com:

I don't get it-- the main Access window? or the Access form?

I would just reccomend
a) not letting people resize forms. Seriously-- maximize them always.
b) not let people see the db window.

-Aaron

Hi Aaron,

Sorry, the main Access window. I use the FormInfo class from the
developer's handbook to control all but my pop up forms. All of my regular
forms are always maximized into all of the MDI space except what the "left
nav" form occupies. The regular forms shrink as the main Access window does
so, resizing, if necessary through their timer events.

Most of my forms have listviews on them that I allow to shrink as the
form shrinks, but at some point, there isn't enough visible to have it be of
value. While it doens't really hurt anything to allow the user to shrink the
window to nothing, I've seen applications that stop at some minimum size. I
figure if they can do it, I can, too.

Regards,
Max