DataBase refreshing is ugly..

Posted on 2000-01-19
Medium Priority
Last Modified: 2010-05-02
I'm designing a DB application.
But whenever I'm moving between pages(At run-time), I see an ugly refresh of the next page table (which is connected to the DB).

I'm asking which way is the best way in those cases, when you are moveing to a different form, which Selects from a table at startup.
First selecting and then showing ?, maybe the other way ?
I tries some ways but it stayed ugly..
Question by:GuryTraub

Accepted Solution

paul_tsekov earned 100 total points
ID: 2370430
Hi ,VBFan
   if you are talking about shoing some grids on different forms, before selecting make the grid invisible
Then fill the grid.
  After that Grid1.Visible=True

  When you have some calculations on visible objects their much slower than in the case when you make the object invisible on the form, then do the calculations and then show the object (make it visible).

   Try this it really works well.

           Pavel Tsekov
       email : paul_tsekov@yahoo.com

LVL 43

Expert Comment

ID: 2371112
You might also consider setting the .redraw property of the grid to false whilst it is being populated and then back to true again. Though if it is invisible this may not have much benefit, if you subsequently recalculate the grid whilst it is displayed it makes for a more rapid and cleaner update.

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.

If you are experiencing a similar issue, please ask a related question

There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
I’ve seen a number of people looking for examples of how to access web services from VB6.  I’ve been using a test harness I built in VB6 (using many resources I found online) that I use for small projects to work out how to communicate with web serv…
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…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

601 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