R
Rick in NS
I have a contacts table and several related tables as follows:
Contacts main table
Addresses many to one related to Contacts
Telephones many to one related to Contacts
Jobs many to one related to Contacts
....... (in all about 15 tables related to Contacts)
I have tried loading the main form Contacts with all fifteen related forms
attached as sub forms. The overhead appears to be to high and the system
slows to a snail's pace. I am therefore using the approach of loading the
main Contact form and subsequently loading one related form only as needed
using string link criteria.
Before loading another sub form the first sub form is closed so that only
one sub form is open at a time. Each sub form has unique fields and
organization so I can't using a standard sub form and change the data source
dynamically.
The problem arises with this matter of display monitor resolution and font
size. If I create the form in 800X600 resolution with the font size set at
96DPI and tinker with window postioning I can eventually get the main form to
load with the sub form positioned where it is supposed to be. However; as
soon as a user using a higher resolution; larger monitor size; or large font
size loads the form and sub form everything is out of alignment. The only
solution appears to be to accept the fact that anyone using a different
monitor size; resolution or font size is going to see the form loaded in the
top left portion of the display with vacant space on the right and bottom.
Attempting to set the AutoCentre and AutoResize is an improvement for the
main form but the sub forms are all different sizes and need to appear in
different locations; so that doesn't work.
I have noted suggestions in the newsgroup to use a utility that enlarges or
shrinks the form to fit the monitor configuration. It has also been
suggested that all related forms be attached to the main form as sub forms
which doesn't work because of the overhead.
Anyone have any other suggestions on how to manage this issue of forms
sizing on monitors with different configurations?
Contacts main table
Addresses many to one related to Contacts
Telephones many to one related to Contacts
Jobs many to one related to Contacts
....... (in all about 15 tables related to Contacts)
I have tried loading the main form Contacts with all fifteen related forms
attached as sub forms. The overhead appears to be to high and the system
slows to a snail's pace. I am therefore using the approach of loading the
main Contact form and subsequently loading one related form only as needed
using string link criteria.
Before loading another sub form the first sub form is closed so that only
one sub form is open at a time. Each sub form has unique fields and
organization so I can't using a standard sub form and change the data source
dynamically.
The problem arises with this matter of display monitor resolution and font
size. If I create the form in 800X600 resolution with the font size set at
96DPI and tinker with window postioning I can eventually get the main form to
load with the sub form positioned where it is supposed to be. However; as
soon as a user using a higher resolution; larger monitor size; or large font
size loads the form and sub form everything is out of alignment. The only
solution appears to be to accept the fact that anyone using a different
monitor size; resolution or font size is going to see the form loaded in the
top left portion of the display with vacant space on the right and bottom.
Attempting to set the AutoCentre and AutoResize is an improvement for the
main form but the sub forms are all different sizes and need to appear in
different locations; so that doesn't work.
I have noted suggestions in the newsgroup to use a utility that enlarges or
shrinks the form to fit the monitor configuration. It has also been
suggested that all related forms be attached to the main form as sub forms
which doesn't work because of the overhead.
Anyone have any other suggestions on how to manage this issue of forms
sizing on monitors with different configurations?