We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Display message during VBA execution in Access

RichNH
RichNH asked
on
Medium Priority
603 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
Comment
Watch Question

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007

Commented:
You can do this using the SysCmd() function.

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

mx
Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Thanks,  I seem to remember some refence to Application but that might have been Excel.  Works like a charm.
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007

Commented:
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
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.