Not happening in order??

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Hi,

Sorry for the rudness of this post, here is my code:

UpdateStatuslbl ("Updating Dispatching Tables...")
DoCmd.SetWarnings False
DoCmd.OpenQuery "qryDisbyL2_ATD_All", acViewNormal, acEdit
DoCmd.OpenQuery "qryDispatched_L2_All_DupRemoval", acViewNormal, acEdit
DoCmd.SetWarnings True
UpdateStatuslbl ("Tables ready...")
UpdateStatuslbl ("")

So, above is a function I created that updates a lable on a form, then I
turn off some warnings while this append query runs (Because yes, I actually
want to populate the table with that data and I don't need bug the user about
it). Now... my problem is that it doesn't update the lable before it starts
running the queries. I have several other subs on this form that follow the
same sort of format, to give the user some (and very simple to the point of
"duuuuhh") feed back that the program is doing something.

My question: How do I get it to change the lable FIRST, then start the query?

Cheers,
 
Hi,

Sorry for the rudness of this post, here is my code:

    UpdateStatuslbl ("Updating Dispatching Tables...")
    DoCmd.SetWarnings False
    DoCmd.OpenQuery "qryDisbyL2_ATD_All", acViewNormal, acEdit
    DoCmd.OpenQuery "qryDispatched_L2_All_DupRemoval", acViewNormal, acEdit
    DoCmd.SetWarnings True
    UpdateStatuslbl ("Tables ready...")
    UpdateStatuslbl ("")

So, above is a function I created that updates a lable on a form, then I
turn off some warnings while this append query runs (Because yes, I actually
want to populate the table with that data and I don't need bug the user about
it). Now... my problem is that it doesn't update the lable before it starts
running the queries. I have several other subs on this form that follow the
same sort of format, to give the user some (and very simple to the point of
"duuuuhh") feed back that the program is doing something.

My question: How do I get it to change the lable FIRST, then start the query?

Cheers,
Click to expand...

stick a DoEvents command between that and the next command. That
forces the application to do complete events in sequential order
instead of asynchronously - where you don't have control over the
sequence - the application determines it for itself.
 
Back
Top