Solved

Label text not appearing during processing...

Posted on 2007-12-05
2
296 Views
Last Modified: 2013-11-07
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

0
Comment
Question by:sirbounty
2 Comments
 
LVL 17

Accepted Solution

by:
ZeonFlash earned 250 total points
ID: 20413894
Did you try putting Application.DoEvents() after you set the text on the label?
 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

Application.DoEvents()

Open in new window

0
 
LVL 67

Author Comment

by:sirbounty
ID: 20414357
Nope - I hadn't...
Thank you very much! :^)
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK (http://www.microsoft.com/en-us/download/details.aspx?id=27876) for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now