Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Mar 2003
    Location
    London, Gtr London
    Posts
    131
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Speeding up Screen Refresh (97)

    Could somebody please tell me if there is a way I can speed up my screen refresh rate?

    I have a menu/contol form in access with command buttons and labels etc. The labels are hidden when the form is opened, but when the user begins the process by clicking the buttons, the labels display the status to the user about what is going on.

    What I have noticed though is that the screen is not getting refreshed quick enough to display the correct message as the query or macro etc. already starts running. So I end up with the labels only showing the details when the query has finished running.

    This may sound a bit daft, but is there a way I can slow the code down so that the displays/labels can update themselves before the next query runs?

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

    Re: Speeding up Screen Refresh (97)

    If the queries finish so fast, perhaps you don't need these labels.

    You can force a form to update itself by issuing Me.Repaint.

  3. #3
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Emerald Beach, New South Wales, Australia
    Posts
    126
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Speeding up Screen Refresh (97)

    after your label.visible = true
    Doevents
    run macro query etc

  4. #4
    2 Star Lounger
    Join Date
    Mar 2003
    Location
    London, Gtr London
    Posts
    131
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Speeding up Screen Refresh (97)

    Dear Hans and Stewart

    Thanks for the help, I have tried both ways and both seem to provide what I am looking for.

    Thanks and kind regards
    Hayden

Posting Permissions

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