Link to home
Start Free TrialLog in
Avatar of RichNH
RichNH

asked on

Display message during VBA execution in Access

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
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

You can do this using the SysCmd() function.

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

mx
ASKER CERTIFIED SOLUTION
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of RichNH
RichNH

ASKER

Thanks,  I seem to remember some refence to Application but that might have been Excel.  Works like a charm.
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