Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

change mouse to busy (clocking)

Discussion in 'Information Technology' started by James, Jul 28, 2006.

  1. James

    James
    Expand Collapse
    Guest

    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.
     
  2. Loading...


  3. Wolfgang Kais

    Wolfgang Kais
    Expand Collapse
    Guest

    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
     
  4. James

    James
    Expand Collapse
    Guest

    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
     
  5. Phillip Windell

    Phillip Windell
    Expand Collapse
    Guest

    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" <jamesburkett@gmail.com> wrote in message
    news:1150986483.439961.219710@y41g2000cwy.googlegroups.com...
    > 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

    >
     

Share This Page