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!
No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.
Your password has been sent to:email@example.com
To follow this tag...
Thanks! We'll email you when relevant content is added and updated.
Share this item with your network: