Hi, I run a very long query. I w

[JPMontreal]

Hi,

I run a very long query. I would like to show a progressbar on the form that I use to start the query., not the status bar. How could I do that.

Thanks,



Jean-Paul
Montreal
To send me E-Mail, remove “USELESSCODE”.
jp@USELESSCODEsolutionsvba.com

 

[GenieTR]

by using Syscmd(acSysCmdInitMeter, strMsg, tblcount)
where strMsg is the message that you want to display and
tblcount is the record counter.

example:

varReturn = Syscmd(acSysCmdInitMeter, strMsg, tblcount)

at the end use varReturn = Syscmd(acSysCmdClearStatus)

 

[JPMontreal]

Hi,
Thanks but this will display the progressbar into the status bar, lower right corner of the screen, if you have a loop to control the process. But it is a query, I don’t have any loop and I want to display a progress bar on the form. I know how to make a progressbar but I don’t know how to control if from a query?

Thanks,



Jean-Paul
Montreal
To send me E-Mail, remove “USELESSCODE”.
jp@USELESSCODEsolutionsvba.com