Link to home
Start Free TrialLog in
Avatar of sirbounty
sirbountyFlag for United States of America

asked on

Label text not appearing during processing...

On my form, I have a link label that basically displays any time that was discovered in the user's Outlook calendar:
xx:yy of appointments found

On the days where there are none, the label simply doesn't appear.

I have all this processing occuring in a sub - and would like the user to know that when they change the date, that the calendar information is being queried, so in that routine, I make the link label visible, and change the text.  However, I never see that bit of information when I run the code.

What could be missing, or how can I get this 'please wait' text to display?
Here's a portion of the code in that routine:
Application.DoEvents()  'thought this would help...but it hasn't
 With lnkAppointments
   .Visible = True 'start out by making the label visible
   .Text = "Retrieving appointments ..." 'change the text to let the user know the appointments are being queried
 End With
 
'[Code to connect with Outlook and retrieve appointments...] 
 
  If ts.TotalMinutes = 0 Then ' if the timespan in minutes is 0, simply hide the link label
    lnkAppts.Visible = False
  Else
    With lnkAppts
      .Text = Format(ts.Hours, "#0") & ":" & Format(ts.Minutes, "00") & " found." ' if the timespan is not 0, then display the amount of time discovered.
  End With

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of ZeonFlash
ZeonFlash

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of sirbounty

ASKER

Nope - I hadn't...
Thank you very much! :^)