Query Ready

[matrixknow]

Hallo,

I activate a maketableqeury with

Docmd.OpenQuery

While running you see automatically the progress bar on your status bar.

However to make it even more user friendly I need to know when the maketable action is complterly finished(then I can set a textbox background value to vgGreen for example).

How can you dedect this ?

 

[CautionMP]

matrixknow,
The code to change the color shouldn't run until after [tt]matrixknow[/tt] has completed so you should be able to do this:

Docmd.OpenQuery
Me.Text1.BackColor = vbGreen

Hope this helps,
CMP

[small]For the best results do what I'm thinking, not what I'm saying.[/small]
(GMT-07:00) Mountain Time (US & Canada)