Access Webb App - Condition to stop macro RRS feed

  • Question

  • Hello,

    hope someone will know this answer. How can i set up a stop macro function when a certain condition is met? i have a table that has an on insert macro to calculate and append new records but right now when i run it, access stops the macro because of an endless loop. i need the macro to add 365 entries from the start date ( a year) and when it hits 365 entries i need the macro to stop. 

    for example, if my first entry is on December 1st 2015, i need the macro to stop when the enty for december 1st, 2016 is entered. 

    Thursday, March 24, 2016 4:32 PM


All replies