Access freezes when printing

[Etienne M. St-Georges]

Hello,
I sent this post earlier at microsoft.public.access.forms, but i think it
might be better if i send it here. Sorry for the multi-post. Here is my
post:

Hi,
I have a program that's been written with Access. In that application,
there
is a form that let you print a sequential batch of sticker, you just need to
specify from what number to what number to print.
The problem is that once the "Print" button has been pressed, the
access-application freezes until the entire data is processed and printed.
How could we avoid this? Is this because access can only manage one job at
a time (in that case, when the application is sending data to the printer,
it
cannot do anything else)?

Thanks,
Etienne

 

[SA]

Etienne:

Access processes commands in a synchronous manner, meaning normally that one
command must finish before the next one begins. So the behaviour your are
seeing is generally expected.

The caveat to that statement is that if your app does a lot of processing
behind the scenes (e.g. pulling or looping through recordsets, etc.) then
you can insert DoEvents calls in your code which allows the running process
thread to pause breifly to allow the user interface to respond to additional
commands.

HTH