L
Leslie Isaacs
Hello All
Does the number of buttons on a form affect its opening speed?
I have a form that takes 30-40 seconds to load - but only the first time
it's loaded: after closing the form, it can be re-opened very quickly! Why
the difference?
Final question: is it possible to copy buttons from one control to another -
ideally more than one at a time - in a way such that their OnClick events
come with them?
The form is based on a simple query that opens almost instantly. The form
did have 6 subforms, about 200 buttons (almost all of which were to open
reports) and about 10 comboboxes and a few checkboxes, but as part of my
efforts to speed it up I removed all the subforms - no effect - then started
removing pages from the tab control - still no effect - finally removed the
entire tab control - finally the form opens quickly, every time. So now I
need to start adding the buttons etc. back, but before I start this (it's
going to be a long job) I wanted to check here whether there's some
fundamental thing I'm doing wrong. I should add that I've done plenty of
decompile/compact+repair/recompile operations, and also tried exporting the
form and re-importing it to/from another mdb, but none of this has helped.
Most of what I've read on the subject (thanks for the links Daniel) seems to
be about subforms, but my problem remains even without any subforms.
Hope someone can help
Many thanks
Les
Does the number of buttons on a form affect its opening speed?
I have a form that takes 30-40 seconds to load - but only the first time
it's loaded: after closing the form, it can be re-opened very quickly! Why
the difference?
Final question: is it possible to copy buttons from one control to another -
ideally more than one at a time - in a way such that their OnClick events
come with them?
The form is based on a simple query that opens almost instantly. The form
did have 6 subforms, about 200 buttons (almost all of which were to open
reports) and about 10 comboboxes and a few checkboxes, but as part of my
efforts to speed it up I removed all the subforms - no effect - then started
removing pages from the tab control - still no effect - finally removed the
entire tab control - finally the form opens quickly, every time. So now I
need to start adding the buttons etc. back, but before I start this (it's
going to be a long job) I wanted to check here whether there's some
fundamental thing I'm doing wrong. I should add that I've done plenty of
decompile/compact+repair/recompile operations, and also tried exporting the
form and re-importing it to/from another mdb, but none of this has helped.
Most of what I've read on the subject (thanks for the links Daniel) seems to
be about subforms, but my problem remains even without any subforms.
Hope someone can help
Many thanks
Les