Hello all. I'm looking for a way to make it where a person can not launch an update macro (launches a update-query) if X date is = to Y date (meaning that it was already updated so it will not allow them to do it twice and tell them so. I tried launching an IIF() in a query and launching a msgbox inside that if it met the requirements, but it would just error out on me. Anyone know of a not too complex way to do this? I don't know how to VB script it or anything.
The way I want it to work is they click "step 3" it prompts them for a date (X). If X ="As of" date in the table then it errors out explaining that the month has already been updated. And if X not= "as of" then the update runs as normal.
Trying to idiot proof if and feeling like one my self
Thanks in advance.
The way I want it to work is they click "step 3" it prompts them for a date (X). If X ="As of" date in the table then it errors out explaining that the month has already been updated. And if X not= "as of" then the update runs as normal.
Trying to idiot proof if and feeling like one my self
Thanks in advance.
