MSFlexGrid slow 2nd time around

Posted on 2003-10-28
Medium Priority
Last Modified: 2013-12-25
The problem I'm having is when I try to fill the grid with a different resultset.  The first time it loads it's lightning fast.  The second time I try to load data its very slow.  The order by clause in both statements is indexed.  I'm lost.  It would seem like there is something I'm not doing with the grid

Question by:JZUPKUS
LVL 42

Accepted Solution

frodoman earned 375 total points
ID: 9637974
Try clearing the resultset & grid completely before reloading it.  I found this solved my identical problem.

I can't explain why it worked because it was mainly a trial & error solution but maybe it'll work for you too ;)
LVL 18

Expert Comment

ID: 9638154
Please post the code.

Author Comment

ID: 9644088
I already use Grid.Clear and closed the resultset.  But, talking/typing this out made me think of something.  The first time the grid is loaded the form is not visible.  So when I went to reload the grid with a different resultset with the form VISIBLE it took a long time.  I added Me.Hide before the load and Me.Show after the grid was populated and it was back to very fast!

This problem has bothered me for a long time and talking it out helped so I'll give you the points Frodoman.  Good thing to remember.  Dec 17th approaches - Return of the King.  


Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…

597 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question