I think the following code does something like you require. It suspends between 9pm and 6am and during the day it 'sleeps' and 'wakes up' every 5 minutes to do something.
Create a form which starts automatically when the database opens and put the code below in the Form_Timer section.
You can...
I have a Windows 95 pc with 2 different access 97 database processes running. These processes are doing a similar job, they have forms sitting on a timer wait, and every 5 minutes they 'wake up' and check if there are any records in an AS400 file using ODBC. Any records found are read and used...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.