You may also want to include a "Do Events" command in the loop. Without that
sometimes the process will tie up the machine to where nothing else works
anywhere until it is finished. Including that command allows the machine to
check for "other things" and need taken care of as it is doing the loop.
It may not be a big deal with it lasting only 5 seconds, but it is something
to keep in mind.
--
Phillip Windell [MCP, MVP, CCNA]
www.wandtv.com
"James" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Thanks alot!
> Wolfgang Kais wrote:
> > Hello James.
> >
> > James wrote:
> > > on a form I have a button that runs a module generating an xml file.
> > > It takes about 5 seconds. During that time I was hoping to change
> > > the mouse arrow to busy, the clocking thing... sorry about my
> > > terminology.
> > > How can I do that? Thanks.
> >
> > Use the Hourglass method of the DoCmd object to turn the
> > hourglass on (true) or off (false):
> >
> > DoCmd.Hourglass True
> > ' code to generate xml file
> > DoCmd.Hourglass False
> >
> > --
> > Regards,
> > Wolfgang
>
Similar Threads
