Progress Bar - execute queries - using increments from embedded st

[MichaelTrainor]

I am executing four queries at a time using DoCmd.OpenQuery. I am also using
a progress bar (seperate form) that initializes at the begining of each
click_command function. After each query is completed I update the progress
bar manually by providing the percentage complete with an update call
function.

Screen.MousePointer = 11
Call acbInitMeter("Processing", False)

' Makes Table

DoCmd.SetWarnings False
DoCmd.OpenQuery "makeMyTable", acViewNormal, acEdit
DoCmd.SetWarnings True
acbUpdateMeter (25)

I would like to initialize and update this progress bar using some sort of
increments that rely on the status bar that is embedded in access...I would
assume that might not be possible as Micorosft is not open-source and that
staus bar is proprietory code.

If there is anyway to declare some sort of variable that can be incremented
DURING the processing of each query, it would be a BIG help.

I've been to DaigleNet and search every other forum I could manage.

Thank you...