how do i check if there is atleast one record in the table in VB
Thedon123 Registered User. Local time Today, 16:21 Joined Sep 11, 2002 Messages 98 Jan 23, 2003 #1 how do i check if there is atleast one record in the table in VB
ColinEssex Old registered user Local time Today, 16:21 Joined Feb 22, 2002 Messages 9,157 Jan 23, 2003 #2 You could use DCount Col
D DJN Guest Jan 23, 2003 #3 If DCount("*", "tblYourTableName") < 1 Then MsgBox "No Data in this table" Exit Sub End If David