Import action

[Guest]

Hello.
Is it possible to capture the end of a "docmd.transferdatabase import ...."
action?

Thanks.

Luis

 

[Alex Dybenko]

Hi,
when next statement after docmd.transferdatabase will be executed - this
means that import finished

 

[Guest]

Ok, but my problem is another.
I have a bd that imports a table from another database and this action may
take a while. I have a form with a rectangle object that works as a progress
bar.
What i'd like is that while the import action is running, this form stays
opened and executing the vba code on it.
When the import action stops, the form will close.

 

[Alex Dybenko]

Hi,
Sorry, but not sure you can do this, all code will stop until import
finishes
Actually Access updates its own progress meter in status bar,