[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Display message during VBA execution in Access

Posted on 2011-04-25
4
Medium Priority
?
589 Views
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.

Rich
0
Comment
Question by:RichNH
  • 3
4 Comments
 
LVL 75
ID: 35462157
You can do this using the SysCmd() function.

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

mx
0
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 500 total points
ID: 35462172
Here is just one example:

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

   ' your code


     Call SysCmd(acSysCmdClearStatus)

mx
0
 
LVL 1

Author Closing Comment

by:RichNH
ID: 35462835
Thanks,  I seem to remember some refence to Application but that might have been Excel.  Works like a charm.
0
 
LVL 75
ID: 35462865
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.

mx
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Question has a verified solution.

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

Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses
Course of the Month17 days, 14 hours left to enroll

830 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