do

do the events

sleep X milliseconds

loop

This program is designed to always run in the
background of a PC and peroidicly wake up and
check for things.  I am closing all connections
to a database before going to sleep.  On average
this program sleeps for 5 or 10 minuites.  I am
experiencing this delay in my CPU performance
when this program is on.  Every program is
delayed when my program is running.  PLEASE
HELP!!!!!

Sent via Deja.com http://www.*-*-*.com/
Before you buy.

?I wrote a program that uses the Sleep call in
?VB.  When the program goes to sleep the CPU is
?delayed.  If I try to open an excel sheet while
?it is sleeping it takes about 3 minuets to open
?the sheet.  Here's an example of the code
?
?do
?
?do the events
?
?sleep X milliseconds
?
?loop
?
?This program is designed to always run in the
?background of a PC and peroidicly wake up and
?check for things.  I am closing all connections
?to a database before going to sleep.  On average
?this program sleeps for 5 or 10 minuites.  I am
?experiencing this delay in my CPU performance
?when this program is on.  Every program is
?delayed when my program is running.  PLEASE
?HELP!!!!!

Every program or just those like Excel, Access, Word, etc., that
make use of VBA?  You might try something like this:

==========
   'for a 5 minute Sleep
   Dim lngI As Long
   For lngI = 1 To 300  '300 1-second Sleeps
      Sleep (1000)
   Next lngI
==========

Worth a shot.

--
Paul Marshall

public function Delay(HowLong as single)
    dim starttime as single
    starttime=timer
    do until timer-starttime>=howlong
        doevents
    loop
end function

then call it like this:
call Delay(300)

this will delay the program for 300 seconds (5 minutes), but not stall
anything.

I wrote a program that uses the Sleep call in
VB.  When the program goes to sleep the CPU is
delayed.  If I try to open an excel sheet while
it is sleeping it takes about 3 minuets to open
the sheet.  Here's an example of the code

do

do the events

sleep X milliseconds

loop

This program is designed to always run in the
background of a PC and peroidicly wake up and
check for things.  I am closing all connections
to a database before going to sleep.  On average
this program sleeps for 5 or 10 minuites.  I am
experiencing this delay in my CPU performance
when this program is on.  Every program is
delayed when my program is running.  PLEASE
HELP!!!!!

Sent via Deja.com http://www.deja.com/
Before you buy.

I have an app that is on a PC running in the background.  It is looking for
MS Games every
two seconds.  Does not take up CPU processing.  I am using the VB Timer.
Works great and
does not pull the CPU down.

Check http://www.vb-helper.com  sample code and for longtime.  Rod Stephens

Bob Askey

-- Roger
  Harry Nilsson Web Pages: http://www.jadebox.com/nilsson/