Code Keeps Running

  • Thread starter Thread starter Heather
  • Start date Start date
H

Heather

I inherited this database and I noticed that the code
keeps running after it has processed through.

I thought buy having the following code it would stop but
the hourglass looks like it still is processing.

rs.Close
Set rs = Nothing

Thanks
 
The code you mention will close and release from memory a recordset object.
For the hourglass, look for code such as

DoCmd.Hourglass True
or
DoCmd.Hourglass False

If it has been set to True, it wills stay there until set to false. Another
possibility would be if the code was stuck in a loop.
 
Hello,

If there is a statement in the code like:

DoCmd.Hourglass True

And this is not followed some time later by a statement like:

DoCmd.Hourglass False

Then the code has finished, but the mouse cursor has not been set back to
normal. In effect this is just cosmetic but can be annoying to a
unsuspecting user.

HTH

--

Cheers
Mark

Free Access/Office Add-Ins at:
http://mphillipson.users.btopenworld.com/
 
Back
Top