Forms opening very slowly.

[Lisa]

Hi.
(Access 2000)
I used to do all my form automation with macros. I'm
converting a database into code now and am having problems
with the time the form takes to open in form view and
design view.

My forms have many subforms, calculated fields, and code,
although I've seen other databases with way more code and
they opened very quickly.

I've compacted, I've compiled, and when I tried to use a
mde file it took even longer to open.

My code all seems to work fine.

Forms that I don't have hardly any code on will open right
away or a count of 2 seconds or so.

Forms with the subforms, calculated controls, and code can
take a count of 8 or so seconds to open in design view.
These same forms when I had macros attached opened in
design view immediately.

Also, I've noticed that as I'm working in Access and open
the VBE window and work with the code, my computer's
available memory can go down to 20% or so and sometimes I
get errors that there's not enough memory to open a form
etc.. I have 256 mb of ram. Also - never had this
problem with macros. (Windows 98)

I have the 3rd patch installed.

Help please
Lisa

 

[Michel Walsh]

Hi,


Is it required to see all the subforms at the same moment? if not, use a
tab-control, place subform on different "page" of the control. Once done,
leave the SourceObject property to nothing for all the pages that are not
visible and, in the AfterUpdate event of the tab-control, accordingly to its
value (its value is the page actually displayed), assign the sub-forms
controls SourceObject to the name of the form to be displayed there,
accordingly to the sub-form controls now visible, given the page displayed.

That should also accelerate the navigation on the main form (moving from
records to records). Loading the sub-forms is relatively slow, limiting that
action to just what is visible accelerate the overall loading process.


Hoping it may help,
Vanderghast, Access MVP