So I have a form set up which has a button.. the onclick event of this button runs some code and produces a report.. This usually takes 2-3 mins.
I am actually looking for a way that if it has been less than 20 mins since the user clicked that button, a macro is skipped (no need since data wont be updated)..i.e a line of code is skipped.
something alone the line:
If datediff("mi", timestamp, now()) < 20 then..
^ something's wrong here .. any suggestions please?