Search results

as I have written previously , I have updatequery(sum)with tow criteria so I need a code that if one of its criteria is not right or empty to show message that "check the name or the writer" and so on and if we can show message then move to second query.

I wrote the code in vba and use update query(sum) but when one criteria isn't achieved , I want a message tells the user that there is wrong in criteria or not achieved then I will use the second query , all these I have done in vba.

I have update query(sum) with tow criteria name1=name2 and the second criteria is writer1= writer2 so in case name1<>name2 or writer1<>writer2 then the action doesn't show any message or warning that there is wrong for to use the second query. is it clear my question?

I have update query(sum) with tow criteria name1=name2 and the second criteria is writer1= writer2 so in case name1<>name2 or writer1<>writer2 then the action doesn't show any message or warning that there is wrong for to use the second query. is it clear my question?

hello I have many queries so how can I use query2 instead query1 when query1'criterias aren't achieved or aren't right. thank