Tip on problem solving in rules

tford · Post by **tford** » Sat Mar 31, 2007 3:03 pm

A trick I learned from an MS Access forum in problem solving macros:

In problem solving a process, you can temporarily turn a rule OFF by putting 1=2 in the condition field. Obviously 1=2 will never be true so that the rule is temporarily turned OFF.

I also use this approach when there is part of a process that I have decided to no longer use. Instead of deleting it, I sometimes will use 1=2 to turn it OFF for awhile until I can make 100% sure I want to delete the item.

Tom

Elmar · Post by **Elmar** » Sat Mar 31, 2007 4:16 pm

Thanks for sharing. It is also a very common thing to use the opposite -> 1=1 in SQL-Where clauses to do mass delete or update operations in a table.