large form

  • Thread starter Thread starter bob
  • Start date Start date
B

bob

hello,
i have a form which currently is 150 megs in it self.
this form has a section of 5 tab controls in it. these
tabs are used to effectly display different areas of
information about a manufactured part. the ms analyzer
tells me to use less controls. i assume this means
break these tab screens into individual forms accessed by
a button or the like. through experimenting i removed
the tab section from this form and i reduced the form by
about 130 megs. can i some how reduce the form size with
out sacrificing the ease of use i get with the tab
section?

thanks and have a great day

bob
 
I could be wrong, but I don't see how a form is 150 mb. How do you know
that? Where do you see the size of your form?

In any case, you could use subforms. Depending on how you lay it out, it
could appear to be one form, but would be much smaller. Sub forms would
typically be used to display data about a record from a different (related)
table. In most cases, subforms are used when one-to-many relationships
exist. The main form would show the customer, and the subform would showw
all their orders (for example).

Doing this will still take about the same time to load, though. Maybe even
longer. If you feel your users truly need to access all the data on one
form, then there is nothing you need to do. I would think that some of the
less-commonly used fields could be moved to a popup form (or forms) that the
user could access when needed.

Rick B

hello,
i have a form which currently is 150 megs in it self.
this form has a section of 5 tab controls in it. these
tabs are used to effectly display different areas of
information about a manufactured part. the ms analyzer
tells me to use less controls. i assume this means
break these tab screens into individual forms accessed by
a button or the like. through experimenting i removed
the tab section from this form and i reduced the form by
about 130 megs. can i some how reduce the form size with
out sacrificing the ease of use i get with the tab
section?

thanks and have a great day

bob
 
Thanks Rick
The way i extimated the form was to create a copy
of the database and distroy just that form then compact.
it turns out i found a big flaw in the way i was placing
pictures in my database. i was not watching and was
embedding a number of pictures. don't ask me why but
when i set all the picures (these were in other forms
also) i reduced the over all database size from 215 mb to
1.4 mb. that sounds crazy to me but it now works much
better.

thanks again for the help

bob
 
Back
Top