Hello, good day, I would like to ask if it is possible to use the contents of a table as a comparator? For example, I have this column in my table that has the schedules of the professor, if the professor for example failed to login within fifteen minutes after his/her supposed start of class a message will be displayed on the screen notifying that the professor has not yet logged in. Thanks. Any help will be greatly appreciated.
Using contents of an MS Access table
- Thread starter topz06
- Start date
Rx_
Nothing In Moderation
- Local time
- Today, 16:33
- Joined
- Oct 22, 2009
- Messages
- 2,795
Would a timer event help? If a timer event ran a procedure every 2 minutes to check the status.
The table holds a StartTime and the TimeProfessorLoggedIn.
The timer event, every 2 minutes runs a function that evaluates Now to the StartTime. If the StartTime is before NOW and the TimeProfessorLoggedIn is still Null...
Then, send message to Professor.
Something along those lines might work.
The table holds a StartTime and the TimeProfessorLoggedIn.
The timer event, every 2 minutes runs a function that evaluates Now to the StartTime. If the StartTime is before NOW and the TimeProfessorLoggedIn is still Null...
Then, send message to Professor.
Something along those lines might work.
Similar threads
