Change cursor to hourglass during import

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

use the do command

this turns on the hour glass
DoCmd.Hourglass True
this turns off the hour glass
DoCmd.Hourglass False

DJ Walker

Network Programmer
(e-mail address removed)
314-781-0900 ext 790

St Louis Zoo
Visit www.stlzoo.org <http://www.stlzoo.org>
The Saint Louis Zoo is accredited by the American Zoo and
Aquarium Association (AZA). Look for the logo whenever you
visit a zoo or aquarium as your assurance that you are
supporting a facility dedicated to providing excellent
care for animals, a great experience for you, and a better
future for all living things. With its more than 200
accredited members, AZA is a leader in global wildlife
conservation, and your link to helping animals in their
native habitats.

-----Original Message-----
I have a module that allows me to import data from a Word
form into my Access database. I have a command button
control on a form that calls this module when you click on
the button. How can I change the cursor from a pointer to
an hourglass whilst the import procedure is running, and
then change back to a pointer when the task has finished?
 
It worked!

Thanks

Geek

use the do command

this turns on the hour glass
DoCmd.Hourglass True
this turns off the hour glass
DoCmd.Hourglass False

DJ Walker

Network Programmer
(e-mail address removed)
314-781-0900 ext 790

St Louis Zoo
Visit www.stlzoo.org <http://www.stlzoo.org>
The Saint Louis Zoo is accredited by the American Zoo and
Aquarium Association (AZA). Look for the logo whenever you
visit a zoo or aquarium as your assurance that you are
supporting a facility dedicated to providing excellent
care for animals, a great experience for you, and a better
future for all living things. With its more than 200
accredited members, AZA is a leader in global wildlife
conservation, and your link to helping animals in their
native habitats.


form into my Access database. I have a command button
control on a form that calls this module when you click on
the button. How can I change the cursor from a pointer to
an hourglass whilst the import procedure is running, and
then change back to a pointer when the task has finished?
 
Back
Top