Recent content by Claudiusjerry

  1. C

    Why can't I opening the same form twice at the same time?

    IS the action of opening a continuous form in access twice in one device Is restricted by the version or hardware or location or connection of the computer? I tested by opening the same continuous form in access (same file name)at the same time in one device, both of them works fine, the data...
  2. C

    The refresh time of a function is too short which results in an infinite loop.

    It's ok, this pause function honestly helped me a lot, I guess I will implement this function in the system if I can't build the most desired one.
  3. C

    The refresh time of a function is too short which results in an infinite loop.

    The system compares the current time and the end time (the time started the timer + the time selected for count down), if they are the same, an "alarm" word will appear in the text box, which is no longer a null/empty box, which triggers the alert. Which is a part of the timer event? I am not...
  4. C

    The refresh time of a function is too short which results in an infinite loop.

    Thanks for explaining it in detail, I have a better understanding of the problem now, but I think I need some more time to figure out how the continuous form works, I started learning VBA last month and still have a lot to learn. 😞😞😔😔
  5. C

    The refresh time of a function is too short which results in an infinite loop.

    So, this is a whole view of my timer table: I applied a double-click function in the column ID, it will remove all data in the row representing ID 1, which is Room 1. Also, I applied a function to the column Nog, when time is up, the logic is: start time (current time) + chosen time (Alarm) =...
  6. C

    The refresh time of a function is too short which results in an infinite loop.

    I'm so sorry for giving too little information about my problem, please give me some time to organize my problem.
  7. C

    The refresh time of a function is too short which results in an infinite loop.

    Oh, This works, but why can I not modify anything during that pause, and the things I modified will be shown after the pause... By the way, how do you write a function that detects the content of a text box, and then clears all row data? Why I tried Text31 = NULL OR Me.Text31 = NULL OR...
  8. C

    The refresh time of a function is too short which results in an infinite loop.

    Yes, I understand now, thank you very much. I will try to delete the alert before moving to the next room.
  9. C

    The refresh time of a function is too short which results in an infinite loop.

    Then is it possible for me to add a new function after the SPEAK and pop-up of Classroom 1 that deletes all Classroom 1 data, goes to Classroom 2 SPEAK, and pops up and deletes? Which delete action is added in the sequence preventing an infinite loop? Or, is it available for deleting row data...
  10. C

    The refresh time of a function is too short which results in an infinite loop.

    um... So there is a drop list box for you to select time, if you select 1 minute (00:01), the time function will add one minute to the current time, if current time = current time + 1 minute, then trigger the Tekst31 to perform "alarm", which triggers the OutOfTime() function. Simply just when...
  11. C

    The refresh time of a function is too short which results in an infinite loop.

    It just detects the change of the Tekst31 box, if it's not empty, then it will trigger alert and pop up window. While the Tekst31 box will be empty when time is still running, and return " alarm" when tine is up, so that's how a non empty Tekst31 box triggers the function. Can you give me some...
  12. C

    The refresh time of a function is too short which results in an infinite loop.

    I tried calling a sub in the function, but it works sometimes, and sometimes no response, why?
  13. C

    The refresh time of a function is too short which results in an infinite loop.

    I understand the concept you mentioned, but it seems does not allow any modification during the pause, so I cannot clear the data by double-clicking the clear box.
Back
Top Bottom