Is there a way in VBA to tell if a query produces no records? Thanks for the help.
J Jarod Oct 23, 2003 #1 Is there a way in VBA to tell if a query produces no records? Thanks for the help.
B Brian Camire Oct 23, 2003 #2 You might open a recordset based on the query and test if both BOF and EOF are True.
V Van T. Dinh Oct 24, 2003 #3 Try: DCount("*", "YourQuery") It should give the number of rows returned by your Select Query, including 0 for no rows returned.
Try: DCount("*", "YourQuery") It should give the number of rows returned by your Select Query, including 0 for no rows returned.
