Go from "waiting" mode to "running" mode

[AUGuy]

I seem to remember a method of telling Access to continue accepting/running commands while an import or some other activity is going on in the background. Unfortunately, I dont have the database I used it in anymore and cannot remember the code. Anyone know what I'm talking about and know the code?

 

[the_net_2.0]

what are you talking about?

I think vba code executes one line after another, but only one process runs at a time.

 

[boblarson]

I think you are wanting

DoEvents

Which will free up the computer's processor to process other things in the queue (other COMPUTER tasks, but not Access tasks) while also doing the import.

 

[AUGuy]

I think you are wanting

DoEvents

Which will free up the computer's processor to process other things in the queue (other COMPUTER tasks, but not Access tasks) while also doing the import.

Thanks, Bob. That's exactly it -- All I could remember is it started with a "D"
I was just starting to run down the list in my index to try to find it.

G

 

[AUGuy]

To anyone wondering, this is the solution I came across when I open a form (in this instance informing the user of a process that has started) just before running an import. Sometimes it will open the form but not display the contents until after the import, which makes a "hey we're importing this file to your database now. please be patient" type of message irrelevant if it only displays AFTER the import finishes.