Status message during running a process

[Guest]

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

 

[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

 

[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!)

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
---------------------------