D DC Gringo Sep 23, 2004 #1 How can I check for the number of records in a table? If MyDataSet1.Table1.recordcount = 0 'my code' End If
How can I check for the number of records in a table? If MyDataSet1.Table1.recordcount = 0 'my code' End If
H Hermit Dave Sep 23, 2004 #2 MyDataSet1.Tables[0].Rows.Count -- Regards, Hermit Dave (http://hdave.blogspot.com)
M Mark Fitzpatrick Sep 23, 2004 #3 MyDataSet1.Table1.Rows.Count Hope this helps, Mark Fitzpatrick Microsoft MVP - FrontPage
D Davide Vernole [MVP] Sep 23, 2004 #4 DC Gringo said: How can I check for the number of records in a table? If MyDataSet1.Table1.recordcount = 0 'my code' End If Click to expand... Try this: If MyDataSet1.Tables("Table1").Rows.Count = 0 Then 'your code here End If
DC Gringo said: How can I check for the number of records in a table? If MyDataSet1.Table1.recordcount = 0 'my code' End If Click to expand... Try this: If MyDataSet1.Tables("Table1").Rows.Count = 0 Then 'your code here End If
S Shiva Sep 23, 2004 #5 Use DataTable.Rows.Count property. How can I check for the number of records in a table? If MyDataSet1.Table1.recordcount = 0 'my code' End If
Use DataTable.Rows.Count property. How can I check for the number of records in a table? If MyDataSet1.Table1.recordcount = 0 'my code' End If
