Re: VBA - Form Progress
- From: dbarmer <dbarmer@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 11 Jun 2009 15:56:03 -0700
It does not. Can you elaborate? I am reading both text files and database
files within the do... loops.
"Dirk Goldgar" wrote:
"dbarmer" <dbarmer@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message.
news:D29CB306-23A0-4B0D-9237-2337511150E0@xxxxxxxxxxxxxxxx
I have a form that is loaded, and behind this form is VBA code, running
both
standard basic code along with database code. On the form I have several
Textboxes that I send data to while looping through data (Me.TextBox) so
the
user see's a progress of the program. Two things happen here, (1) If
the
user goes away from the display progress form, to the desktop or to
another
place within the computer, and then comes back to the access progress
form,
IT's solid white.... You can see nothing but an hourglass.
I am using Me.Repaint and Me.Refresh inside of the Do....Loop actions,
however, it still does this no matter how often I refresh/repaint. When
the
program finishes, it suddenly comes back to life.
What could be the cause or resolution? It's not computer memory or
anything
like that....
Your loop should include a DoEvents statement. Does it?
--
Dirk Goldgar, MS Access MVP
www.datagnostics.com
(please reply to the newsgroup)
- Follow-Ups:
- Re: VBA - Form Progress
- From: Dirk Goldgar
- Re: VBA - Form Progress
- References:
- VBA - Form Progress
- From: dbarmer
- Re: VBA - Form Progress
- From: Dirk Goldgar
- VBA - Form Progress
- Prev by Date: Re: VBA - Form Progress
- Next by Date: Re: VBA - Form Progress
- Previous by thread: Re: VBA - Form Progress
- Next by thread: Re: VBA - Form Progress
- Index(es):
Relevant Pages
|