I have an access application that uses tables in access to create custom documents in Word. All sorts of stuff is happening... certain sections are eliminated based on checkboxes that the user enters into forms, certain text is replaced... certain things are formatted... all based on how the user specified things on forms.
It turns out that MS Office is working pretty hard doing all these things (there are quite a few replaces, etc). Rather than have the user stare at the computer for a minute while its crunching, I would like to set up a progress bar that both shows progress and also a message about what the app is doing at the moment.
I would imagine that I could set it up as a function sub where I send it a little message from whatever routine Im running that contains the message text as a string. The bar should then increment a certain amount while displaying the message and then return to the current sub. Can someone help me out with the syntax of this routine by providing a code example of the sub and explaining how to call it?