I have a database with around 40 queries. I have a module which runs all the queries using the following (abbreviated) code:
On Error GoTo RunQueries_Err
DoCmd.OpenQuery "Query_1", acViewNormal, acReadOnly
DoCmd.Close acQuery, "Query_1"
DoCmd.OpenQuery "Query_2", acViewNormal, acReadOnly
DoCmd.Close acQuery, "Query_2"
It works fine, but what I want to do now is copy this code and add a condition that Field_3 (which appears in all queries) should be set to "n". Suggestions most welcome.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!