Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    195
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Routine progression? (2003)

    I have a procedure that manipulates several recordsets. In order to follow the progression I have added a text box in a form to display the record number of one of the recordsets. I have used the repaint method but unfortunately the textbox doesn't follow the progression of the procedure.
    What is the best way to have the progression in real time.
    Thanks and regards,
    Marcel

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Routine progression? (2003)

    At the end of the loop or after the line that update the textbox, add a line :
    DoEvents
    Francois

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Routine progression? (2003)

    Hard to say without knowing the code, and how the text box is ppoulated, but try inserting a line

    DoEvents

    and/or

    Me.Recalc

    somewhere in the loop.

  4. #4
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    195
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Routine progression? (2003)

    thank you it works perfectly

    Regards,

    Marcel

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •