forms load slowly.

  • Thread starter Thread starter Hitesh Joshi
  • Start date Start date
H

Hitesh Joshi

Hi,
I am an MS Access newbie.
I have a form with two subforms. Main form and subform both quries the
SQL db though ODBC link. When I run main form and subforms
independently, they are very fast but as soon as I put them together in
a single form (main form + subforms), it takes 3-4 seconds to load.
There are not any complex calculation involved.
Is there anyway I make this load fast or atleast make it appear
faster.. like load main form and then have a button that can make
subforms visible?


Thank you,
hj
 
Use the Debugger to single step throouh your form's code (maybe, the ONOpen
evnet) to see what taking so long.

I'll bet that there is some code is being executed multiple times.
 
Hitesh Joshi said:
Hi,
I am an MS Access newbie.
I have a form with two subforms. Main form and subform both quries
the SQL db though ODBC link. When I run main form and subforms
independently, they are very fast but as soon as I put them together
in a single form (main form + subforms), it takes 3-4 seconds to
load. There are not any complex calculation involved.
Is there anyway I make this load fast or atleast make it appear
faster.. like load main form and then have a button that can make
subforms visible?


Thank you,
hj
Click to expand...

I'm sure, if you take the time to search these groups with terms
relating to performance, you will find much information. Then there
are also those who have compiled a bit of information on the topic,
like for instance

http://www.granite.ab.ca/access/performancefaq.htm
http://www.fmsinc.com/tpapers/faster/index.html
 
Back
Top