Access GUI "lock-up" behavior

F

fringesurfer

Hello,

I am developing a slew of access apps that do extensive Long running queries
repeated in loops, unfortunately that code running makes access go into (not
responding) mode and locks up all GUI INCLUDING updates of the progress bar.
Does anyone has any links to sample solutions to that problem OR tips and
hints ? MUCH appreciated

r
 
F

fringesurfer

I answered my own question searching MSDN

for anyone facing this in long running code

DoEvents <--- will allow system handling of GUI
During your code execution
 
Top