Display message during VBA execution in Access

Posted on 2011-04-25
Last Modified: 2012-05-11
I run a VBA routine in Access whereby I populate a table.  I would like to display a message on the bottom of the screen in the bar where the READY and the caps lock message displays (or someplace else if not there) that shows where I am in the process of updating.  How can I do this?  I seem to recall that there is a simple one line command that allows me to do this.

Question by:RichNH
    LVL 75

    Expert Comment

    by:DatabaseMX (Joe Anderson - Access MVP)
    You can do this using the SysCmd() function.

    If you look that up in VBA Help ... all the details are there.

    LVL 75

    Accepted Solution

    Here is just one example:

        Call SysCmd(acSysCmdSetStatus, "Processing ....")

       ' your code

         Call SysCmd(acSysCmdClearStatus)

    LVL 1

    Author Closing Comment

    Thanks,  I seem to remember some refence to Application but that might have been Excel.  Works like a charm.
    LVL 75

    Expert Comment

    by:DatabaseMX (Joe Anderson - Access MVP)
    You are welcome.

    Check out the info in the Help file. You can also use it as a progress meter on the Status bar (the area you were referring to) ... it works pretty cool.


    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
    A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
    With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

    729 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

    18 Experts available now in Live!

    Get 1:1 Help Now