Check the DoEvents function, if your process is in a loop, you can put the it inside the loop and it will allow other things to be processed. Check out Access help
You should get Total Visual Code Tools one of the tools allows you to copy sql from the access query builder and it automatically makes a vba variable for you. It has a bunch of other helpful tools. well worth the price.
http://fmsinc.com/MicrosoftAccess/VBACodingTools.html