Alt J An Awesome Wave Zip there. A Custom Progress Bar that can be pasted into any form. **The full code listing seen in this video is available at: The progress bar that is built into Microsoft Access is small and displays at the bottom of the Access window. It is often not seen by users. In this video we will build a custom progress bar that can be copied and pasted into other forms very easily. In addition, all of the VBA code needed to make it work is encapsulated in a single method.

Making deployment of the task bar a two step copy and paste function: copy the controls from the form and paste, then copy one VBA method and paste. All of my videos organized by topic and other blog topics.

Feb 01, 2008 Hi, I have a progress bar on my form which I have setup my using; Public pgBar As MSComctlLib.ProgressBar When my form is.

I have this function (it is a function, as I believe you can only call functions from macros) that is to update the status bar that I run between steps of a macro. However, it isn't working. During the running of the macro, I only see my last status bar after the macro has finished running. Function StatusBar(Optional varQuery As Variant) Dim Stat As Variant If Not IsMissing(varQuery) Then If varQuery ' Then Stat = SysCmd(acSysCmdSetStatus, 'Query Running: ' & varQuery) Else Stat = SysCmd(acSysCmdClearStatus) End If Else Stat = SysCmd(acSysCmdClearStatus) End If End Function My only idea is that I set Echo and SetWarnings to NO at beginning of macro and set them to YES at end. But I sent them to yes *after* my last status bar update, and that status bar message still displays. After looking, I now wonder why I don't use the ECHO function, since it seems to have a 'Status Bar Text' field.