How to make a Form/Report open quickly ?

  • Thread starter Thread starter Naveen
  • Start date Start date
N

Naveen

Some of my Access Forms/Reports contain lot of controls on
them.
It takes a long time to open.
How can I Optimize the Form/Report Design and the Code to
open forms quickly ?
What are the ways to optimize a report when we have
several gruping levels on it ?
 
Hi Naveen,

Forms open slowly for mainly 2 reasons:
1. The data source or query is taking a long time to retrieve the data
2. The forms contains a large number controls

In the first case, try optimizing your datasource by changing your queries
in a way that will allow faster data retrieval. For example, if you're
using aggregate function in the query, first create a query to filter the
data without aggregate and then use that query to design your aggregate
view. There are many ways to optimize queries, and it's pretty much a
matter of tweaking and testing.

In the second case where you might have too many controls on a form for
efficiency, I would recommend using subforms to break out different sets of
data. You can use some code to load the subforms only when the user needs
them and this will help optimize the form. I usually offer a tabbed or
wizard interface to users with subforms that load on demand for the sake of
efficiency.

Hope this helps,
- Glen
 
Dear Glen,
Thank you very much for the guidelines.I will try to
improve the quality of my works using them.Thank you !
-Naveen
 
Back
Top