jkfeagle Codus Confusious Local time Today, 06:18 Joined Aug 22, 2002 Messages 166 Sep 6, 2006 #1 Can someone tell me the VBA code for testing whether a query recordset is empty or not?
G grnzbra Registered User. Local time Today, 11:18 Joined Dec 5, 2001 Messages 376 Sep 6, 2006 #2 db.openrecordset if rs.eof then msgbox "recordset is empty" else msgbox "recordset is not empty" end if
db.openrecordset if rs.eof then msgbox "recordset is empty" else msgbox "recordset is not empty" end if
