[AccessD] Access Has Stopped Working! (Working Solution)

[Dan Waters]

Does Access dream of Cross-Tab Queries?

I probably have ... :-)

Dan

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman
Sent: Thursday, November 03, 2016 11:23 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Access Has Stopped Working! (Working Solution)


Yes and no.

DoEvent yields the processing time to the OS, but your code remains active.

Sleep on the other hand tells the OS to put the process on to sleep for that
amount of time, and nothing executes.   When the sleep is over, you'll be on
the next line of code.

No need to be used together; when you sleep, everything else gets time.

Jim.

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark Simms
Sent: Thursday, November 03, 2016 11:11 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Access Has Stopped Working! (Working Solution)

Does the Sleep API function provide the same functionality as the DoEvents loop ?

Or should they be used together ?

DoEvents
Sleep 500 ' Wait 1/2 second



--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com