Quick Popup Message boxes during Processing

Posted on 2006-06-05
Last Modified: 2008-02-01
Hi There,

This is probably a very simple question.    

I need to bring up a message box to tell the user what is happening...   Now I don't want normal message box that has the "OKAY" "CANCEL" button on it.... I just want an information box that appears for the length of time that is required to process the request.   I want this to disappear when the process is complete.

Is there anything that does this? Sorry if this a little basic.

Question by:GusK
    LVL 65

    Expert Comment

    what u could do is when u start your process is to start a new form

    this form could have no toolbars, just text, make it look like a message box
        DoCmd.OpenForm "frmWait", acNormal

    then when processing complete, u can close the form
        DoCmd.Close acForm, "frmWait"

    LVL 65

    Assisted Solution


    have a label with big text saying WORKING....
    u can make it flashing by using the form's timer method

    set this

    Me.TimerInterval = 2000

    this in form_timer

    if lblWait.ForeColor = white then lblWait.Forecolor = ref else lblWait.ForeColor = white

    note, I used used colour names, not the numeric value for it

    this is just to give u an idea

    LVL 27

    Expert Comment


    How about giving the message in the status bar:

    -- To Set The Message -------------
    Call SysCmd(acSysCmdSetStatus, "HI THERE!!")

    -- To Clear The Message -----------
    Call SysCmd(acSysCmdClearStatus)

    LVL 14

    Accepted Solution

    if you use rockiroad's first suggestion (a normal form that is made to look like a dialog box), you can place a text field into it and put text dynamically into it on the fly:

    suppose the form is called "frmProgress", and the text field is called "txtCurrentActivity", use e.g. these code lines:

      Forms("frmProgress").Controls("txtCurrentActivity") = "Now calculating averages..."

    (instead of DoEvents you can try Forms("frmProgress").Form.Repaint, but you need something like that, otherwise the text in the field isn't really updated).


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    This article is a continuation or rather an extension from Cascading Combos ( and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

    759 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

    13 Experts available now in Live!

    Get 1:1 Help Now