Re: VBA - Form Progress

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



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)


.



Relevant Pages

  • Re: When typing stops, record saves automatically
    ... >> record to the database and clears the form for the next entry. ... > this control? ... Is there a Timer event firing ... > Dirk Goldgar, MS Access MVP ...
    (microsoft.public.access.formscoding)
  • Re: Front End being locked
    ... copying into a blank database, ... testing a install routine. ... Dirk Goldgar, MS Access MVP ...
    (microsoft.public.access.modulesdaovba)
  • Re: I get the error msg: Error accessing File. Network Connection
    ... I make my database and work ... this KB article describes a nasty bug that may have bitten you: ... > Office 2000 SP3 fixes the bug, but that won't repair your corrupted ... > Dirk Goldgar, MS Access MVP ...
    (microsoft.public.access.modulesdaovba)
  • Re: Need Help Understanding This
    ... If so, please compact it and zip it to reduce the download time, and send it to the address derived by removing NO SPAM and ".invalid" from the reply address of this message. ... Do *not* post my real address in the newsgroup -- I don't want to be buried in spam and viruses. ... Upon examination of the database, it turns out that the problem was that the subform's Data Entry property was set to Yes, preventing it from showing any existing records. ... Dirk Goldgar, MS Access MVP ...
    (microsoft.public.access.forms)
  • Re: pattern matching
    ... > database are used in this field and if so create a link to those words. ... > already showing the meaning of the word (taken from the meaning field). ... at the command prompt and *use the Perl debugger*. ... Proper indentation of the loops would help understanding of ...
    (comp.lang.perl.misc)