Access 2010 VBA - dialog that opens when you run a query, closes when you run a query
I have a request that takes a little time to complete. My users do not understand that the request is executed after the button is clicked because there is no dialog box or text explaining what steps it takes. My question is:
Is it possible to create a dialogue box that appears when a query begins, and closes when a query ends?
If it is possible to update the dialog (i.e. when my first subformation is updated, put a field in the box Updating User information
and when my second subformation is updated,
Calculating Monthly Suggestions
) in VBA. I am using this in my Access 2010 database.
TIA!
source to share
although the pony2deer link suggests the Application.StatusBar solution. I've found that the status bar doesn't grab the user's attention and often goes unnoticed.
I would recommend using a form that is displayed just before the request is executed, then hidden immediately after the request is complete. If you already have a form open (sounds like you), you can simply add a shortcut to the form and update the signature. Update it to # 1 below right before the request is executed. Then update it to # 2 immediately after the request is finished processing.
1.) labelStatus.Caption = "Please wait while your request is processed ..."
2.) labelStatus.Caption = "Success! Your request has finished processing."
Raise the font size, make it bright, etc. You really want the status to pop up so that your users don't walk around and affect the performance of your application.
source to share