Status message during running a process

K

KentAE

Hi
I have an AutoExec macro as via a VBA-function runs a lot of
create-a-table-queries. The hole process takes about one hour to execute.
I would like to have some MsgBox, or something likes that, showing which
query is runing.
Thank's in advance
 
G

Graham R Seach

Kent,

Check Help for:
syscmd acSysCmdInitMeter
syscmd acSysCmdUpdateMeter
syscmd acSysCmdRemoveMeter

When you update the meter, provide the name of the query that will be
executed next in the sequence. Make sure to issue the DoEvents statement
before actually calling each query, otherwise you may not see the meter
update.

Regards,
Graham R Seach
Microsoft Access MVP
Canberra, Australia
 
D

Douglas J Steele

Or

SysCmd acSysCmdSetStatus
SysCmd acSysCmdClearStatus

which will let you put text without a progress meter.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Graham R Seach said:
Kent,

Check Help for:
syscmd acSysCmdInitMeter
syscmd acSysCmdUpdateMeter
syscmd acSysCmdRemoveMeter

When you update the meter, provide the name of the query that will be
executed next in the sequence. Make sure to issue the DoEvents statement
before actually calling each query, otherwise you may not see the meter
update.

Regards,
Graham R Seach
Microsoft Access MVP
Canberra, Australia
---------------------------
Click to expand...
 
Top